Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
I have a sub that needs to fire any time a worksheet activates. I know how
to put the code below "behind" each worksheet, but was wondering if there a way to place the code in a "Workbook" event so the code would achieve the same results and execute any time a different sheet gets activated, but only have to keep it in one place? I have about 25 worksheets within my workbook and was trying to be more efficient. CODE: Private Sub Worksheet_Activate() Call mySub End Sub |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
How do I activate the first worksheet? | Excel Programming | |||
Add-ins and Worksheet activate | Excel Programming | |||
Change Worksheet Button Caption on Worksheet.Activate | Excel Programming | |||
Activate Previous worksheet after adding a new worksheet | Excel Programming | |||
Worksheet activate | Excel Programming |