Custom Password Template to Auto-Hide Data in Worksheets
TeachExcel
0:00 / 0:00
Custom Password Template to Auto-Hide Data in Worksheets
14 233 просмотра · 4 г. назад
TeachExcel
268 тыс. подписчиков
14 233 просмотра · 4 г. назад
Excel VBA/Macro Course! [On Sale]: https://www.teachexcel.com/vba-course...
Download the File: https://www.teachexcel.com/excel-tuto...
Scrollable Boxes in Excel: • Make Perfect Scrollable Boxes in Worksheet...
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.
To build powerful VBA projects or further customize this one, checkout my full VBA Course: https://www.teachexcel.com/vba-course...
Resources:
Protection in Excel (Microsoft Link): https://support.microsoft.com/en-us/o...
#msexcel #tutorial #vba #exceltips #freetutorial #exceltips #excel