PC Review


Reply
Thread Tools Rate Thread

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

 
 
phpons@gmail.com
Guest
Posts: n/a
 
      28th May 2008
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 With Quote
 
 
 
 
paul.robinson@it-tallaght.ie
Guest
Posts: n/a
 
      28th May 2008
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,
>
> 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 With Quote
 
john
Guest
Posts: n/a
 
      28th May 2008
Have a look at this article it may give you some guidance.
http://support.microsoft.com/kb/280454
--
jb


"(E-Mail Removed)" 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
>

 
Reply With Quote
 
 
 
Reply

Thread Tools
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
Disable Password Dialog Close Workbook David McNaughton Microsoft Excel Programming 1 15th Feb 2007 08:42 PM
avoid being asked to delele files or not? seeeker Microsoft Frontpage 9 4th Oct 2005 08:26 PM
How do I avoid having Southafrican email recipients being asked t. =?Utf-8?B?R2F5?= Microsoft Outlook Discussion 1 28th Oct 2004 03:23 PM
how to avoid being asked for password =?Utf-8?B?Tm9ybWE=?= Windows XP Help 3 18th Jun 2004 11:59 PM
Open en close a workbook with password Morrigu Microsoft Excel Programming 1 16th Apr 2004 04:37 PM


Features
 

Advertising
 

Newsgroups
 


All times are GMT +1. The time now is 11:35 PM.