Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 8
Default Auto Open won't die or go away

This has been a strange week for me - at least with excel (2002)

I prototyped some code as part of an auto_open sub.
When the application was more advanced I put the auto_open code
into the workbook open event and deleted the auto_open macro.

The next time I opened the file it froze on me. After 20 minutes of
troubleshooting I was able to figure out that it froze because the
auto_open macro was gone.

I put a blank auto_open sub and it ran perfectly, no freeze on open.
I searched all the code (knowing in advance the outcome) and could not
find any reference to auto_open elsewhere in the sheets or modules.

in passing, i have never referenced auto_open in any application i've
created and i have almost always use workbook open instead of
auto_open.....very strange stuff that it freezes without it.

What gives?
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
Auto open workbook(s)? Shek5150 Excel Discussion (Misc queries) 6 August 29th 08 05:58 PM
Auto Open Macro Launchnet Excel Worksheet Functions 7 July 20th 07 07:41 PM
how do you switch from auto open Jay Excel Discussion (Misc queries) 3 July 18th 05 04:29 PM
Auto Open Syed Zeeshan Haider Excel Discussion (Misc queries) 2 June 1st 05 03:39 PM
Auto Open Todd[_5_] Excel Programming 2 September 4th 03 05:57 PM


All times are GMT +1. The time now is 04:03 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"