How to fix run time error '91'

  • Thread starter Thread starter Bonnie
  • Start date Start date
B

Bonnie

Someone at my work was doing something with Excel. Now when I try to exit I
get a message saying run time error '91'. They said they don't know what
happened. This only pops up and prevents exit when I try to hide a
spreadsheet that was hidden from before.
Does anyone have a clue?
Thanks.
 
It sounds like the file has some macro(s) in it. I'd start by using
[Alt]+[F11] to open the VB Editor and then use Debug --> Compile VBA Project
and see if it points out any error in the code.

If that checks out OK, then do a search in the VB code for the name of the
sheet that you are hiding before exiting, it could be that some piece of code
is trying to reference that sheet and cannot because you have hidden it. Be
sure when you do the search that you elect to search the entire Project, not
just the current routine or module.
 
Back
Top