MrExcel Publishing
Your One Stop for Excel Tips & Solutions

VBA Project Protection Problems

Posted by Randy on February 02, 2002 7:42 AM

I am using Excel 2000. I want to protect the macros in my workbook from being viewed and edited.
I right clicked on the project in the project explorer window and then went to the protection tab in the properties window. I checked "lock project from viewing" and entered the password and confirmed.
After that, I select the project and it still allows me to view the macros and edit as well.

Can someone plese tell me what I am doing wrong?



Posted by Barrie Davidson on February 02, 2002 7:48 AM

Randy, try closing the file and then re-opening it. I seem to remember seeing somewhere that the password won't "take effect" until you close the file.

Let me know if my memory is still okay.

BarrieBarrie Davidson

Posted by Randy on February 02, 2002 8:42 AM

That did it.
Thanks, Barrie!