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

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

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

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

On May 28, 8:57*am, wrote:
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

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

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


" wrote:

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