Перейти к содержимому

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