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

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

phpons@gmail.com - 28 May 2008 08:57 GMT

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

Reply to this Message

paul.robinson@it-tallaght.ie - 28 May 2008 10:19 GMT

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, php...@gmail.com wrote:

> Hi all,
>
[quoted text clipped - 7 lines]
>
> Philippe

Reply to this Message

john - 28 May 2008 10:39 GMT

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

Signature

> Hi all,
>
[quoted text clipped - 7 lines]
>
> Philippe

Reply to this Message