Do you share workbooks for collaboration with collogues but would like a secure private worksheet within the shared workbook for your notes?
HERE IS HOW.
0:00 Intro
1:45 Analyzing the Workbook and Worksheets
3:14 Protecting the worksheet with a password
4:19 Hiding and unhiding a worksheet
5:24 Protecting the workbook so the worksheet can not be unhidden
7:05 How to unprotect your workbook and worksheet
7:49 Important note about the protection when you close your workbook
9:19 What do you do if you forget your Passwords
Link to video on breaking Excel Password if you forget your password.
[ Ссылка ]
