Assign password to "Very Hidden" worksheet

E

exalan

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top