Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Macro to run when sheet activated
i would just put this code in the trigger sheet code module, then it would only
fire when the trigger sheet is activated or deactivated. right click the trigger tab and choose view code and paste this there with the appropriate changes to your sheet names Private Sub Worksheet_Activate() Sheets("sheet1").Visible = True Sheets("sheet2").Visible = True End Sub Private Sub Worksheet_Deactivate() Sheets("sheet1").Visible = False Sheets("sheet2").Visible = False End Sub -- Gary "JDay01" wrote in message ... I would like to have certain sheet tabs that are normally hidden in my workbook to be "unhidden" when I select a specific sheet tab. For example, let's say I have 3 hidden sheets named A, B, and C. Then, let's say I have an unhidden sheet called "Trigger", that when I select it, it executes a macro to unhide sheets A, B, and C. Seems like this should be easy to do ... can someone help? |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Macro to run when sheet activated | Excel Programming | |||
Password prompt when sheet is activated | Excel Programming | |||
userform open when sheet activated | Excel Programming | |||
Load VBA on Activated Sheet | Excel Programming | |||
Error sheet when macro's are not activated | Excel Programming |