Using VB I have hidden all tabs-except the main page- and have macros assigned to buttons on the Main page, and was wondering how to code the button macro to unhide the assigned tab when I click the button.
Here is an example of the button macro code:
Sub transition() ' '
Sheets("Transition").Select Range("H24").Select
End Sub
Thanks in advance for the help, Jeff
Jeff,
You don't need to select anything
Sub transitionHide()
'
'
Worksheets("Transition").Visible = xlSheetHidden
End Sub
Sub transitionShow()
'
'
Worksheets("Transition").Visible = xlSheetVisible
End Sub
Advertisement