assigning macros

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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".
 
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.
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Alt+F11, writing macros and assigning to a button 2
How to identify macro assigned to toolbar button 3
How to assign macro coding into customized button? 4
Assigning Macro to a Command Button 3
losing command button functionality 4
Access Automatically Send a notification email once a record is added 0
Assign a macro to the save button 4
Command Button Excel 2007 4

Back
Top