ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Excel crashes when I open the file, except..... (https://www.excelbanter.com/excel-programming/412479-excel-crashes-when-i-open-file-except.html)

MiNK

Excel crashes when I open the file, except.....
 
I have a problem that does the following:

Start Excel
Open file 'Order Form' (Order Form is my VBA program)
Excel asks to enable/disable macros
Enable macros
Excel crashes

Now if I do the following:

Start Excel
Open file 'Order Form'
Excel asks to enable/disable macros
Disable macros
Save file (same name/location)
Close file (not Excel)
Open file
Enable macros
Program opens fine.

I suspect that there is some environmental setting that has to be set and
this is initiated by saving.

Anybody have any ideas as I'm losing my mind!!!

Cheers

MiNK




All times are GMT +1. The time now is 03:12 AM.

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