Home |
Search |
Today's Posts |
|
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
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. |
#2
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
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. "Bonnie" wrote: 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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Visual Basic Error Run Time Error, Type Mismatch | Excel Discussion (Misc queries) | |||
I tried to get around the problem of the pivot table field settingdefaulting to Count instead of Sum by running a macro of change the settingfrom Count to Sum. However, when I tried to run the Macro, I got error messageof run time error 1004, unable | Excel Worksheet Functions | |||
Receiving run-time error only part of the time | Excel Discussion (Misc queries) | |||
run-time error '91'-Close Button error | Excel Discussion (Misc queries) | |||
Run time error 1004, General ODBC error | New Users to Excel |