In my file a user pastes data into a sheet. A macro then sorts, formats and otherwise manipulates the data and then puts it into 2 sheets which are ready to print in management approved format. I then eliminate the sheets that are not needed and save the file as the account name (located in a specific cell).
Up to this point (with all the help I've gotten here) it works well and will save us about 75 hours per month. However, when I go to reopen the saved file, Excel crashes. I don't need any macros in this saved file and I think (but what do I know?) that they may be the problem. BTW, Excel crashes whether or not I enable the macros. Other info that may have bearing: Excel 2000, Workbook_Open code on deleted sheet, multiple vba modules.
Any suggestions??
Lisa
Up to this point (with all the help I've gotten here) it works well and will save us about 75 hours per month. However, when I go to reopen the saved file, Excel crashes. I don't need any macros in this saved file and I think (but what do I know?) that they may be the problem. BTW, Excel crashes whether or not I enable the macros. Other info that may have bearing: Excel 2000, Workbook_Open code on deleted sheet, multiple vba modules.
Any suggestions??
Lisa