Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 7
Default Excel crashes on close - macro related

I have a macro that runs when an excel file is closed. It repositions
the active cell so the top of the sheet pops up when you open the
file.

However I have found that if you X out of the whole Excel program
without doing a file-close, the program crashes and you have to abort
the program. This doesn't have any impact on the file itself, but it
is annoying.

Is there code I can put in my macro to prevent this crash from
happening, assuming some people will X out of the window before doing
a file-close?

Thanks,
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
Excel crashes on "Close" Visual Basic error 400 [email protected] Excel Discussion (Misc queries) 3 March 19th 08 03:45 PM
Macro to close excel okanem Excel Discussion (Misc queries) 1 July 19th 05 10:01 AM
Excel 2003 crashes when I close any worksheet Greg V Excel Discussion (Misc queries) 0 December 2nd 04 11:25 PM
Excel VBA - Excel crashes when macro button re-assigned problem PaulC Excel Programming 6 April 17th 04 08:57 PM
Excel crashes with .Close command Rich[_16_] Excel Programming 1 December 6th 03 03:34 AM


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