View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Patrick C. Simonds Patrick C. Simonds is offline
external usenet poster
 
Posts: 343
Default Code corruption problem

I have a problem that is driving me up the wall.

I have a workbook with an extensive set of VBA code. I can save the workbook
a hundred times and rerun my code with no problems but if it saves upon
closing Excel, the next time you open it and run the code it crashes Excel.
I have tried everything I can think of to fix this but Excel provides no
information on what is crashing the program.

Now I am wondering if I can suppress the save on exit prompt. No change will
be made to the workbook without going through a UserForm so I can run a save
routine when the UserForm is dismissed.