LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 175
Default Macro now opens up VBA editor - not intended

This is very strange. I ran a macro in a worksheet that does quite of
few routines, and has worked good up until now. Today, I ran it, and at
the end of it all, it now opens up the VBA Editor, and shows all the
UserForms, and Modules.

I have never had it do this. I don't even know how to write the code
for that.

I noticed all this when I ran the macro today, and at the very end of
all the routines, it asked for the PW to open up the editor. (I've had
a PW on it since I started building macros in it.)
I removed the PW, opened the workbook up again, and ran the macro. It
still went to the editor, and opened up all the forms, modules, etc.

Any ideas why this is happening?
Thanks,
J.O.

 
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
Visual Basic Editor opens bi itself KG Excel Discussion (Misc queries) 0 September 15th 07 04:02 PM
VB editor opens by magic dallag Excel Programming 4 January 10th 06 01:23 PM
Computer Lock opens up VB editor Phaedrus Excel Programming 2 December 6th 05 12:45 AM
macro not working as intended Michael A Excel Programming 4 March 7th 05 01:29 AM
VBA Editor opens by itself? Ed[_18_] Excel Programming 0 May 11th 04 05:29 PM


All times are GMT +1. The time now is 08:30 AM.

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

About Us

"It's about Microsoft Excel"