Run-time error 91 occurs in Excel 2000

[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.

 

[Jan Karel Pieterse]

Hi 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.

See:

www.jkp-ads.com/Articles/StartupProblems.htm

Regards,

Jan Karel Pieterse
Excel MVP
http://www.jkp-ads.com

 

[rmcneill944]

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

 

[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