ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Excel crashes on close - macro related (https://www.excelbanter.com/excel-programming/304841-excel-crashes-close-macro-related.html)

Bert[_3_]

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,


All times are GMT +1. The time now is 09:06 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com