I am having a problem when using "Save As" on a particular workbook I have
developed. The workbook contains three separate sheets each containing a
number of macros. Each time I "save as" I get the standard "Microsoft Excel
has encountered a problem message". Interestingly I do not have a problem
when I perform a standard "save" on the workbook, only when I try and change
it's name using "save as". One way I have found to work around this is to
select the "Manual" option for Calculations on the Tools/Options menu.
Leading me to believe that some kind of forced calculation on the workbook
before the save event is causing a problem. Can anybody shed any light on
this and suggest a possible solution.

Many thanks as always.

Andy T