How to avoid being asked for a VBA password on workbook close?

[phpons]

Hi all,

I have a workbook with VBA code that is protected with a password.
I use the workbook, and when I close it, I get a message box that asks
for the project password!!

How can I get rid of this "behavior"?

TIA,

Philippe

 

[paul.robinson]

Hi
Is there some code in the Workbook_BeforeClose event that is calling
the form? In the Editor, go to the ThisWorkBook code module.
regards
Paul

 

[john]

Have a look at this article it may give you some guidance.
http://support.microsoft.com/kb/280454