View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Bert[_3_] Bert[_3_] is offline
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,