Thank you for responding.
I should have been a little clearer. ActiveWorkbook.Close does in fact close
only the active workbook. As I mentioned, it closes the workbook then the
Microsoft error reporting dialog appears and another instance of excel
starts. I am currently using ActiveWorkbook.Quit which works with the odious
downfalls that I am trying to avoid. What could be crashing to cause the
€śMicrosoft Excel has encountered a problem€ť dialog to start. Work is full of
other macros but I am not a
VB expert by any means. All of the other macros
basically unhide and hide sheets for users to view information from several
different pivot tables. Oh, by the way Office 2007