Password Protect & Hide Worksheets in Excel

VBA/Macros Course (80% Discount): https://www.teachexcel.com/vba-course...

Excel File: https://www.teachexcel.com/excel-tuto...
Hide Password Characters:    • Make a Password Prompt Input for Exce...  

Slicer Power Analysis in Excel:    • Slicer Power Analysis in Excel - Pivo...  

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...
- Building Professional Forms: https://www.teachexcel.com/premium-co...

TeachExcel.com

#msexcel #howto #tutorial