Run-time error 91 occurs in Excel 2000

R

rmcneill944

A user closes her Excel program and receives a Run-time error 91. I used
Detect and Repair and still the error occurs. It happens even if there is a
blank worksheet open. I log in as administrator and the same error occurs.
Any help is appreciated.
 
R

rmcneill944

Thanks, I'll be back at this customer's site tomorrow and I'll give it a try.
Rose
 
B

Bill Manville

Some macro is running and trying to use an object variable which has
not been set to refer to an object.

Either it's code in the workbook concerned or in a workbook loaded by
the user as an add-in or from the user's XLSTART directory.

Probably in an Auto_Close or Workbook_BeforeClose macro.

Bill Manville
MVP - Microsoft Excel, Oxford, England
 
Top