Removing VBA Password
 

With password entered and project viewable select your workbook/project then
right-click and VBAProject PropertiesProtection.

De-select the "lock project for viewing" and delete the password dialogs.

Save then close your workbook.

Re-open to find no VBA password protection.


Gord Dibben MS Excel MVP

On Sat, 30 Dec 2006 10:29:00 -0800, pglufkin wrote:

When entering the VBA password, and then trying to save my code, when I try
to bring up the excel sheet again with the code in it that I have saved, I
have to enter the VBA password all over again to get to my code. How do I
permanently remove the VBA password so I don't have to keep on entering it
each time I bring the excel spreadsheet up and try to get into my code?