VBA protection

[Billy]

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

 

[Gord Dibben]

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

 

[Billy]

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





- 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

 

[Gord Dibben]

Glad to have assisted.

Gord

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