 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
| HomeDiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWordDirectoryUser Groups Related Topics Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ... |
MS Office Forum / Excel / Programming / March 2008What can inhibit an event handler?
XL2003 on XP In one instance of Excel, I had two files open and then opened a third file that has a macro that should fire on workbook_open. For some reason, this macro did not run. I closed the third file and tried this twice more with no success. In a second instance of Excel I opened this file and the macro fired. I know that if I had a macro running (or stopped for some reason) and I opened the third file, I would not expect its workbook_open event handler to run. I know that wasn’t the case here. Does anyone know of anything else that could cause this to happen? It’s not a show stopper, but it certainly has me puzzled.  SignatureAl C Just a thought. You haven't run a macro with Application.Enable.Events = false and then not turned the events back on again with Application.Enable.Events = true? SignatureRegards, OssieMac > XL2003 on XP > In one instance of Excel, I had two files open and then opened a third file [quoted text clipped - 8 lines] > that could cause this to happen? It’s not a show stopper, but it certainly > has me puzzled. That's it! I had interrupted an original macro to do some debugging and forgot that it never ran all the way to reset the switch. Thanks, OssieMac. SignatureAl C > Just a thought. You haven't run a macro with Application.Enable.Events = > false and then not turned the events back on again with [quoted text clipped - 12 lines] > > that could cause this to happen? It’s not a show stopper, but it certainly > > has me puzzled. I have a small sub called Oops() that resets these things. - Jon ------- Jon Peltier, Microsoft Excel MVP Tutorials and Custom Solutions Peltier Technical Services, Inc. - http://PeltierTech.com _______ > That's it! I had interrupted an original macro to do some debugging and > forgot that it never ran all the way to reset the switch. [quoted text clipped - 24 lines] >> > certainly >> > has me puzzled. |
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2008 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.