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
getting an error if it is hidden. If not it works.
Thanks
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
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.
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
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
Post your code.
Gord Dibben MS Excel MVP
J
Jeremy
This is what I was needing. Thank you for your help.
J
Jeremy
The code has to go to the hidden sheet. I figured it out. Thanks you for
the imput.
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.
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.
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.