Back to Browse

Password Protect & Hide Worksheets in Excel

62.8K views
Mar 9, 2021
14:04

VBA/Macros Course (80% Discount): https://www.teachexcel.com/vba-course-update.php?src=youtube_v_description_bMAlW_U24tk Excel File: https://www.teachexcel.com/excel-tutorial/2407/hide-show-worksheets-using-a-password-excel-vba-tutorial?nav=yt Hide Password Characters: https://www.youtube.com/watch?v=Y2k3uAM6N-A Slicer Power Analysis in Excel: https://www.youtube.com/watch?v=jZgL6DGcoB4 This works by showing the user a password input window and, if they input the correct password, they can view the hidden worksheets, otherwise the worksheets stay hidden and cannot be viewed. This adds a nice user-interface and data management solution to your workbook and I show you how to apply it to any workbook. The hidden worksheets in this tutorial cannot be viewed by right-clicking a sheet tab and clicking Unhide and they cannot be viewed by manipulating the project itself, because that will also be protected. Excel Courses: - VBA/Macro Course: https://www.teachexcel.com/vba-course-update.php?src=youtube_v_description_2_bMAlW_U24tk - Building Professional Forms: https://www.teachexcel.com/premium-courses/68/idiot-proof-forms-in-excel?src=youtube_v_bMAlW_U24tk TeachExcel.com #msexcel #howto #tutorial

Download

0 formats

No download links available.

Password Protect & Hide Worksheets in Excel | NatokHD