Assign password to "Very Hidden" worksheet
Hello
After making a worksheet "VeryHidden" in VBE, I tried to protect this VBAProject with a password by going to VBAProjectProperties and select Protection, Lock Project from viewing, assign the password and press Alt+Q to go back to Excel, save & close the file. However, when I re-open the file and press Alt+F11 to VBE , there's no prompt for password to open the VBAProject and I can access to the Excel Objects straight away. Please advise steps I've missed in assinging the password? Many thanks -- exalan |
All times are GMT +1. The time now is 08:07 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com