Using macros to unhide tabs

Last Edited By Krjb Donovan
Last Updated: Mar 05, 2014 10:00 PM GMT

Question

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

Answer

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

©2020 eLuminary LLC. All rights reserved.