Macro Help
 

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

Macro Help
 

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.

--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"Jeremy" wrote in message
...
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

Macro Help
 

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
--
Best Regards,

Luke M
*Remember to click "yes" if this post helped you!*


"Jeremy" wrote:

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

Macro Help
 

Code can operate on veryhidden sheets.

Post your code.


Gord Dibben MS Excel MVP

On Tue, 1 Sep 2009 06:47:02 -0700, Jeremy
wrote:

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

Macro Help
 

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

"Luke M" wrote:

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
--
Best Regards,

Luke M
*Remember to click "yes" if this post helped you!*


"Jeremy" wrote:

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

Macro Help
 

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


"Don Guillett" wrote:

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.

--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"Jeremy" wrote in message
...
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

Macro Help
 

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

--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"Jeremy" wrote in message
...
This is what I was needing. Thank you for your help.

"Luke M" wrote:

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
--
Best Regards,

Luke M
*Remember to click "yes" if this post helped you!*


"Jeremy" wrote:

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

Macro Help
 

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.

"Don Guillett" wrote:

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

--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"Jeremy" wrote in message
...
This is what I was needing. Thank you for your help.

"Luke M" wrote:

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
--
Best Regards,

Luke M
*Remember to click "yes" if this post helped you!*


"Jeremy" wrote:

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