Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 270
Default VBA Password box appearing at close

I have a workbook which contains macros. Just recently when I close the
workbook the vba editor password box has started to appear after excel has
shut down. The vba editor was never opened!
I can either supply the password and click "Ok", or I can click cancel twice
without supplying the password, and it disappears.
Any ideas why this has started happening - I have not changed any code, to
cause this.

Thanks
Sandy

  #2   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 35,218
Default VBA Password box appearing at close

This used to be a common complaint for people who were using Google's desktop
search.

Any chance you're using that program?

or...

Did you start to record a macro and then decide not to (a long shot!)?

Sandy wrote:

I have a workbook which contains macros. Just recently when I close the
workbook the vba editor password box has started to appear after excel has
shut down. The vba editor was never opened!
I can either supply the password and click "Ok", or I can click cancel twice
without supplying the password, and it disappears.
Any ideas why this has started happening - I have not changed any code, to
cause this.

Thanks
Sandy


--

Dave Peterson
  #3   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 270
Default VBA Password box appearing at close

Should have mentioned Excel 2003 - does not happen with a converted book in
2007.
Sandy

"Sandy" wrote in message
...
I have a workbook which contains macros. Just recently when I close the
workbook the vba editor password box has started to appear after excel has
shut down. The vba editor was never opened!
I can either supply the password and click "Ok", or I can click cancel
twice without supplying the password, and it disappears.
Any ideas why this has started happening - I have not changed any code, to
cause this.

Thanks
Sandy


  #4   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 270
Default VBA Password box appearing at close

Hi Dave
I don't use Google's Desktop Search Dave and I haven't got any half recorded
macros either - BUT - I had dabbled with "Microsoft Office Live Add-in"
toolbar.
I have just uninstalled it and the problem has disappeared.
Don't know why it should have caused this but....... seems to be the
culprit!!
Sandy

"Dave Peterson" wrote in message
...
This used to be a common complaint for people who were using Google's
desktop
search.

Any chance you're using that program?

or...

Did you start to record a macro and then decide not to (a long shot!)?

Sandy wrote:

I have a workbook which contains macros. Just recently when I close the
workbook the vba editor password box has started to appear after excel
has
shut down. The vba editor was never opened!
I can either supply the password and click "Ok", or I can click cancel
twice
without supplying the password, and it disappears.
Any ideas why this has started happening - I have not changed any code,
to
cause this.

Thanks
Sandy


--

Dave Peterson


  #5   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 35,218
Default VBA Password box appearing at close

If I recall correctly, the problem with the google desktop search (maybe fixed
now????) was that it tried to get into the VBE to examine and index the code in
the workbook's project.

Maybe that MS Office Live addin is doing a similar thing????

I don't recall anyone complaining about that addin, though. But maybe it's more
of a comment on how often it's used <vbg.

Sandy wrote:

Hi Dave
I don't use Google's Desktop Search Dave and I haven't got any half recorded
macros either - BUT - I had dabbled with "Microsoft Office Live Add-in"
toolbar.
I have just uninstalled it and the problem has disappeared.
Don't know why it should have caused this but....... seems to be the
culprit!!
Sandy

"Dave Peterson" wrote in message
...
This used to be a common complaint for people who were using Google's
desktop
search.

Any chance you're using that program?

or...

Did you start to record a macro and then decide not to (a long shot!)?

Sandy wrote:

I have a workbook which contains macros. Just recently when I close the
workbook the vba editor password box has started to appear after excel
has
shut down. The vba editor was never opened!
I can either supply the password and click "Ok", or I can click cancel
twice
without supplying the password, and it disappears.
Any ideas why this has started happening - I have not changed any code,
to
cause this.

Thanks
Sandy


--

Dave Peterson


--

Dave Peterson
Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

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


Similar Threads
Thread Thread Starter Forum Replies Last Post
How to avoid being asked for a VBA password on workbook close? [email protected] Excel Programming 2 May 28th 08 10:39 AM
vba-password prompt on close kikde Excel Programming 3 November 15th 05 01:38 PM
VBA project password on close mmm9999[_2_] Excel Programming 5 August 24th 05 07:28 AM
Close where no password? scottwilsonx[_9_] Excel Programming 0 July 7th 04 12:35 PM
Open en close a workbook with password Morrigu Excel Programming 1 April 16th 04 04:37 PM


All times are GMT +1. The time now is 06:31 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"