Custom Password Template to Auto-Hide Data in Worksheets
Hide and un-hide data in a worksheet with a simple password input!
The password is also masked using asterisks like this **** so that the password will not be visible after it has been input.
No VBA or Macros are used in this tutorial.
This tutorial is another take on how to use a password to protect your data and to make it magically appear and disappear within the worksheet. This is not the strongest way to protect your data, but, combined with a password protected worksheet, it can be quite effective and quite useful.
Resources
Protection in Excel (Microsoft Link)
Question? Ask it in our Excel Forum
Excel VBA Course - From Beginner to Expert
200+ Video Lessons 50+ Hours of Instruction 200+ Excel Guides
Become a master of VBA and Macros in Excel and learn how to automate all of your tasks in Excel with this online course. (No VBA experience required.)
Tutorial: In Excel you can actually hide data that is stored within a worksheet. This allows you to ...
Tutorial: How to allow only certain people to edit certain cells or ranges in Excel. This is a sec...
Tutorial: Perform basic functions on a filtered dataset in excel, including SUM, AVERAGE, COUNT, COU...
Macro: This macro will hide all formulas within a workbook and not allow them to be deleted. The ...
Tutorial: Tutorial showing you how to make a user enable macros in a workbook in order to view the w...
Tutorial: How to group data together or collapse it in order to focus only on the important data in...
Subscribe for Weekly Tutorials
BONUS: subscribe now to download our Top Tutorials Ebook!
Excel VBA Course - From Beginner to Expert
200+ Video Lessons
50+ Hours of Video
200+ Excel Guides
Become a master of VBA and Macros in Excel and learn how to automate all of your tasks in Excel with this online course. (No VBA experience required.)