Hidden tabs

[Davidns]

I need to be able to hide a tab (and password protect it), but have a macro button on an unhidden tab that references cells on the hidden tab. Apparently, when the tab is hidden, the macro fails. Is there a way around this?

 

[Alex Blakenburg]

Show us your macro. If you don't use Select or Activate in your macro, you should be able to read from a hidden worksheet.

 

[Davidns]

Ahh, that was easy. Thank you!

 

[Alex Blakenburg]

You've got to be lucky sometimes

 

[Davidns]

Amen to that!