Turn off VBA protection?

[johnohio]

I have an old spreadsheet that I want to work on. I know the password and I can open the VBA.

I would like to turn off the password protection of the VBA code so I don't have to go through entering the password every time the open file.
I can't for the life of me remember how to do it.

Again, I know the password to get to the VBA code, I just don't want to enter it every time I want to work on updating it.

Thanks!!

 

[Jamie McMillan]

Hello John,

Open VBA editor, Alt F11.
Select 'Tools' then 'VBA Project Properties'. Select the protection tab - delete the password and save.

Jamie

 

[johnohio]

Thanks!

 

[Jamie McMillan]

Hello John,

Glad to have helped.

Can you mark the answer; so that it is closed; and nobody else spends time on it.

Jamie