Combining Two Hide Tab Macros

[tmleynek]

Hi all,

I currently have two macros running and I would like to combine these. I have one macro that hides about half of the tabs (Set1) when you click a button on the ribbon. I also have a macro where I have an inputs tab and depending on what value is picked there, some tabs are also hidden (VariableTabs). I want to be able to be able to click the button on the top ribbon and have the two macros comibine, so hide the Set1 tabs including the Variable tabs, and not be able to unhide them until something changes in the inputs tab.

Please let me know if that makes sense. Coding below.

Please Login or Register  to view this content.

Please Login or Register  to view this content.

[Bernie Deitrick]

Something like

Please Login or Register  to view this content.