Microsoft Excel - Password to Open Specific Sheets
Learn how to use easily inserted macros to control access to worksheets. This is different from protecting changes to cells using a password; this prevents access to unauthorized sheets while granting access to authorized sheets.
(The passwords for the VBA Editor and Worksheet Protection are "password")
File Download Link:
https://www.bcti.com//wp-content/YT_D...
Link to video demonstrating worksheet cell access by username:
• Microsoft Excel - Allow Edit Ranges
00:48 Access Sheet - Password Demonstration
01:10 Mission Objectives
02:06 Password to Unhide a Sheet
04:34 Macro to Hide Sheet
05:01 Protecting the Workbook
08:30 Assigning Macros to Launch Buttons
09:19 Plugging the Sheet Access Loopholes
11:46 Locking the Visual Basic Editor