Macro Help

[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

 

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

 

[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

 

[Gord Dibben]

Code can operate on veryhidden sheets.

Post your code.


Gord Dibben MS Excel MVP

 

[Jeremy]

This is what I was needing. Thank you for your help.

 

[Jeremy]

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

 

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

 

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