Dropdown to hide and unhide tabs

[ksachs24]

i have 3 tabs that I want to hide and unhide as needed with a dropdown list (tab1, tab2, tab3), the dropdown list is on a tab called "menu" and my options yes and no, (yes means i need to see the tab and no means its not needed and it can be hidden) I am using office 365 and need help with the code to get this accomplished, can someone assist?

[KOKOSEK]

Into "menu" sheet code:

Please Login or Register  to view this content.

that's will be checking visibility of our 3 sheets when you choose tab name from dropdown (and change text on button accordingly).

Into standard module:
1. changing visibility of chosen sheet:

Please Login or Register  to view this content.

2. checking and changing text on button (mentioned above)

Please Login or Register  to view this content.

assign macro changeVisibility() into button and should works.


Capture.JPG

Check attached file.

p.s. if you prefer veryHidden (not possible to unhide under right mouse button), change main line in changeVisiblity into:

Please Login or Register  to view this content.

[ksachs24]

Fantastic, I will give it a try and let you know. Really appreciate it!