VBA protection

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Billy - 02 Jan 2008 16:41 GMT

I have a spreadsheet with the VBA protected. when i click on the file
name in the vba project window, i have to type in the password to
expand it to see the sheets and modules. i have another spreadsheet,
and have the vba protected, but the protection seems to not work.
could anyone tell me why perhaps?
Thanks,
tonso

Reply to this Message

Gord Dibben - 02 Jan 2008 17:36 GMT

Protection of VBA Priects doesn't take place until the workbook has been saved,
closed and reopened.

Does this apply in your case?

Gord Dibben MS Excel MVP

>I have a spreadsheet with the VBA protected. when i click on the file
>name in the vba project window, i have to type in the password to
[quoted text clipped - 3 lines]
>Thanks,
>tonso

Reply to this Message

Billy - 02 Jan 2008 20:09 GMT

> Protection of VBA Priects doesn't take place until the workbook has been saved,
> closed and reopened.
[quoted text clipped - 12 lines]
>
> - Show quoted text -

Gord,
You are absolutely right! I thought i had done that, but obviously
not. Still, i did not know that had to take place anyway, so i learned
something!

thanks!
Tonso

Reply to this Message

Gord Dibben - 02 Jan 2008 22:29 GMT

Glad to have assisted.

Gord

>> Protection of VBA Priects doesn't take place until the workbook has been saved,
>> closed and reopened.
[quoted text clipped - 20 lines]
>thanks!
>Tonso

Reply to this Message