Thread: Macro Help
View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.misc
Jeremy Jeremy is offline
external usenet poster
 
Posts: 184
Default 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