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