I am using Excel 97.

I have a macro that runs on the network. Now I know for a fact that I
am the only one on the network right now. And I know that the file is
only opened by me.

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.

I hit cancel and let C++ open up debugger. It claims "Access
violation"

How can this be. I am the only one using the spreadsheet, but each and
everytime I try to close it. The spreadsheet crashes.

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