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.
Protection in Excel (Microsoft Link)