| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Progmatically add code to worksheet_activate
Hi,
I have a macro that creates a new worksheet, however when it does this i want it to add some code to the worksheet_Activate event of the new sheet. Assuming the new worksheet is called "NewYP" and the code i would like in activate_Sheet event is Private Sub Worksheet_Activate() Toolbars.YPBar End Sub How do i go about adding the code ? All help is appreciated Luca |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| If statement syntax to see if Worksheet_Activate code exists | Excel Programming | |||
| Progmatically adding controls in multipage | Excel Programming | |||
| Private Sub Worksheet_Activate() | Excel Programming | |||
| Worksheet_Activate | Excel Programming | |||
| Worksheet_Activate | Excel Programming | |||
Threaded Mode
