Rich wrote:
The macro goes thru it's calculations and so forth. Then I activate
it, save it and when I go to close the spreadsheet. Excel crashes.


Do you have an address at which the failure happens?
Does Excel only fail on close with this particular workbook?
Does the workbook make changes to your menus / toolbars?
Does it help if you rename your <username8.xlb file?


Bill Manville
MVP - Microsoft Excel, Oxford, England
No email replies please - reply in newsgroup