tonywatsonhelp
Well-known Member
- Joined
- Feb 24, 2014
- Messages
- 3,194
- Office Version
- 365
- 2019
- 2016
- Platform
- Windows
Hi Everyone
In sheet Control I have a List of all the sheets in my document
i want to hide some and show other tabs
In column A Range A2:A120 I have the sheets names
in Column B i have either "Hide" or Unhide
I need a macro that when run will Unhide all sheets then hide the ones marked as "Hide"
Please help if you can
Thanks
Tony
In sheet Control I have a List of all the sheets in my document
i want to hide some and show other tabs
In column A Range A2:A120 I have the sheets names
in Column B i have either "Hide" or Unhide
I need a macro that when run will Unhide all sheets then hide the ones marked as "Hide"
Please help if you can
Thanks
Tony