Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
assigning macros
I have over 100 command buttons on a worksheet. I also over 100 macros each
one has to be added to a command button. Is there a quicker way than using "Assign Macro". |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
assigning macros
Maybe you could use a macro to assign the macros. But how do you know which
macro is assigned to which button? And are these commandbuttons from the control toolbox toolbar or buttons from the Forms toolbar. If they are commandbuttons from the control toolbox toolbar, then you don't assign the macro. Those commandbuttons have their own _click events. enyaw wrote: I have over 100 command buttons on a worksheet. I also over 100 macros each one has to be added to a command button. Is there a quicker way than using "Assign Macro". -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Assigning Macros to Buttons | Excel Discussion (Misc queries) | |||
how do I run excel 4.0 macros on excel 2000 | Excel Discussion (Misc queries) | |||
Assigning Macros to Buttons in Excel | Excel Worksheet Functions | |||
Problem Assigning Macros | Excel Worksheet Functions | |||
assigning macros to buttons or autoshapes | Excel Worksheet Functions |