| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Dynamically adding a macro to a new worksheet
How can I programmically add a macro to a new worksheet that was just
created? I want to add a macro called "Private Sub Worksheet_Activate()" with control lines for making toolbar buttons visible or not visible. Any help or direction will be greatly appreciated. Best regards, Fred |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Dynamically adding a macro to a new worksheet
Hi Fred,
See Chip Pearson's page on VBE programming: http://www.cpearson.com/excel/vbe.htm --- Regards, Norman "Fred Russell" wrote in message ... How can I programmically add a macro to a new worksheet that was just created? I want to add a macro called "Private Sub Worksheet_Activate()" with control lines for making toolbar buttons visible or not visible. Any help or direction will be greatly appreciated. Best regards, Fred |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Dynamically adding a macro to a new worksheet
See Chip Pearson's page on programming the VBE for an example:
http://www.cpearson.com/excel/vbe.htm -- Regards, Tom Ogilvy "Fred Russell" wrote in message ... How can I programmically add a macro to a new worksheet that was just created? I want to add a macro called "Private Sub Worksheet_Activate()" with control lines for making toolbar buttons visible or not visible. Any help or direction will be greatly appreciated. Best regards, Fred |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Dynamically adding a macro to a new worksheet
Thanks for your help! Spot on.
|
|
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Dynamically adding a macro to a new worksheet
Thanks for the help! Spot on.
|
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Dynamically Adding Textbox To Frame | Excel Worksheet Functions | |||
| Dynamically adding code | Excel Programming | |||
| Adding Pivot Tables Dynamically | Excel Programming | |||
| Dynamically adding data to a Combobox? | Excel Programming | |||
| Adding button dynamically | Excel Programming | |||
Linear Mode
