Macro Help

J

Jeremy

How do you run a macro when a reference is on a supper hidden sheet. I am
getting an error if it is hidden. If not it works.

Thanks
 
D

Don Guillett

Always nice to start a new thread with YOUR question instead of hijacking an
old one. Also, always nice to show us your code for comments. I suspect that
you have code that is SELECTING the sheet when it probably isn't necessary.
 
L

Luke M

How exactly are you referring to the cell in the macro? (code please!)

Could always try something like:

Application.ScreenUpdating = False
Sheets("YourSheet").Visible = xlVisible

'rest of code goes here

Sheets("YourSheet").Visible = xlVeryHidden
Application.ScreenUpdating = True
 
G

Gord Dibben

Code can operate on veryhidden sheets.

Post your code.


Gord Dibben MS Excel MVP
 
J

Jeremy

The code has to go to the hidden sheet. I figured it out. Thanks you for
the imput.
 
D

Don Guillett

You probably could have and SHOULD have used code that did not require
SELECTING. You should try to learn how to do it properly.
 
J

Jeremy

I appreciate the advise from an expert. With what I was trying to accomplish
my code had to be written the way it was. I have fiexed the code so it works
with a hidden sheet. Thanks again for your opinions.
 
Top