When Hiding/Unhiding Tabs(Worksheets) Need to change button status

[zagzook]

I have a Tab sheet that has Buttons to each sheet and a hide/show button for each sheet when i click my hide button the text changes from Hide to Show and then Disables the Linked button. and of course when I click on Show it changes back to Hide and enables the linked button.

What I am looking for is if some one actually goes and hides the sheet (or Unhides the sheet) from the Tabs instead of the buttons is there way to change the button statuses.

so Example if I hide "Sheet1" from right clicking the tab and selecting hide, is there way to have the Hide button for Sheet1 now will show "Show" and the Linked button is disabled.

thanks
Jeff

 

[Roderick_E]

You could loop through all the sheets and see if they are hidden or not and have this macro update the buttons accordingly. Maybe trigger it with Worksheet_change or something?

 

[zagzook]

Rederick_E Thank you very much I just needed that boost it worked.......