Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Macro "on off" switch
I have a very simple macro assigned to a button that unhides a sheet Sub HR_Training() ' ' HR_Training Macro ' Unhide only the HR Training Hard Dollar Cost Savings Sheet ' ' Application.ScreenUpdating = False Sheets("HR - Training").Visible = True Sheets("Selection Sheet").Select End Sub -- What I would like to do is add a "toggle" type of functionality so that the first press of the button will unhide the sheet, and the next time it will hide it.. any help would be most appreciated.. Thanks Larry |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Macro "on off" switch
Try this...
Sub HR_Training() ' ' HR_Training Macro ' Unhide only the HR Training Hard Dollar Cost Savings Sheet ' Sheets("HR - Training").Visible = not Sheets("HR - Training").Visible End Sub -- HTH... Jim Thomlinson "Larry Fitch" wrote: I have a very simple macro assigned to a button that unhides a sheet Sub HR_Training() ' ' HR_Training Macro ' Unhide only the HR Training Hard Dollar Cost Savings Sheet ' ' Application.ScreenUpdating = False Sheets("HR - Training").Visible = True Sheets("Selection Sheet").Select End Sub -- What I would like to do is add a "toggle" type of functionality so that the first press of the button will unhide the sheet, and the next time it will hide it.. any help would be most appreciated.. Thanks Larry |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Macro "on off" switch
Use
Sheets("HR - Training").Visible = Not Sheets("HR - Training").Visible in place of Sheets("HR - Training").Visible = True "Larry Fitch" wrote: I have a very simple macro assigned to a button that unhides a sheet Sub HR_Training() ' ' HR_Training Macro ' Unhide only the HR Training Hard Dollar Cost Savings Sheet ' ' Application.ScreenUpdating = False Sheets("HR - Training").Visible = True Sheets("Selection Sheet").Select End Sub -- What I would like to do is add a "toggle" type of functionality so that the first press of the button will unhide the sheet, and the next time it will hide it.. any help would be most appreciated.. Thanks Larry |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Macro "on off" switch
Thanky you to the both of you..
works like a champ !! -- Thanks Larry "Sheeloo" wrote: Use Sheets("HR - Training").Visible = Not Sheets("HR - Training").Visible in place of Sheets("HR - Training").Visible = True "Larry Fitch" wrote: I have a very simple macro assigned to a button that unhides a sheet Sub HR_Training() ' ' HR_Training Macro ' Unhide only the HR Training Hard Dollar Cost Savings Sheet ' ' Application.ScreenUpdating = False Sheets("HR - Training").Visible = True Sheets("Selection Sheet").Select End Sub -- What I would like to do is add a "toggle" type of functionality so that the first press of the button will unhide the sheet, and the next time it will hide it.. any help would be most appreciated.. Thanks Larry |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Shortcut to switch from "fill down" to "copy" with mouse drag | Excel Discussion (Misc queries) | |||
Disabled "Switch Row/Column" when creating chart from a pivot tabl | Charts and Charting in Excel | |||
Excel - Golf - how to display "-2" as "2 Under" or "4"as "+4" or "4 Over" in a calculation cell | Excel Discussion (Misc queries) | |||
Why does excell switch my stock symbol "ACN" to "CAN"? | Setting up and Configuration of Excel | |||
Macro to concatenate into "B1" B2 thru B"x" based on new data in "Col A" | Excel Discussion (Misc queries) |