Password prompt for VBA project appears after Excel quits

[quick62silver]

I have been working on VBA code for an Excel spreadsheet. During this coding effort I password protected the VBA code. Since I have password protected the VBA code I get prompted to enter the password for it several times when I exit the spreadsheet. If I do nothing in the spreadsheet and just exit it does not usually happen. This usually happens if I do an activity which involves opening up a userform and perform an operation. Obviously I do not want to release this spreadsheet to the users with this situation nor do I want to not have a password on the VBA code either.

I have been reading about this and some people mention it is because the Google toolbar is installed on the computer. I do not have this issue so it is something else.

Please advise.

 

[quick62silver]

Everyone,

As a followup I did do further testing. First, the file is saved as an .xls as some people are using Excel 2003 and others are using Excel 2007. I had someone using 2003, open it, make changes and then close it and it did not prompt them for the VBA password. Using the same file I opened it in 2007 and made similar changes. When closing the spreadsheet it did prompt me for a password. After hitting the enter key 5 times it stopped prompting me.

Can anyone please advise as to why and how I might be able to resolve this issue.

 

[Gruuuu]

You'd have to post the code.
Maybe something going on with a Workbook_Close() block?