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,
|