Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 82
Default How to fix run time error '91'

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   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 2,203
Default How to fix run time error '91'

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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Visual Basic Error Run Time Error, Type Mismatch Meg Partridge Excel Discussion (Misc queries) 12 September 10th 08 06:10 PM
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 Enda80 Excel Worksheet Functions 1 May 3rd 08 02:35 PM
Receiving run-time error only part of the time [email protected] Excel Discussion (Misc queries) 0 August 11th 07 12:01 AM
run-time error '91'-Close Button error ASCO IS Help Excel Discussion (Misc queries) 1 May 8th 06 04:25 PM
Run time error 1004, General ODBC error [email protected] New Users to Excel 0 September 19th 05 01:41 AM


All times are GMT +1. The time now is 05:15 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"