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?
-
If you would like to post, please check out the MrExcel Message Board FAQ and register here. If you forgot your password, you can reset your password.
Hidden tabs
- Thread starter Davidns
- Start date
Alex Blakenburg
MrExcel MVP
- Joined
- Feb 23, 2021
- Messages
- 9,254
- Office Version
- 365
- Platform
- Windows
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.
Upvote
0
Solution
Alex Blakenburg
MrExcel MVP
- Joined
- Feb 23, 2021
- Messages
- 9,254
- Office Version
- 365
- Platform
- Windows
You've got to be lucky sometimes 
Upvote
0
Similar threads
- Question
