Making code accessible to many buttons

  • Thread starter Thread starter S. S.
  • Start date Start date
S

S. S.

I am trying to create several sheets with identical
buttons. I want the button to do the exact same thing
from each sheet. How do I make this code be in some
overhead location that any of the buttons can call it.
Right now the code seems to only be associated with the
one button on the one sheet. Only that button will call
the code. The other buttons do nothing.

Thoughts?
Does this make sense?

Thanks

S.S.
 
Put your code in a regular code module. If your buttons are from the
Forms toolbar, right-click the buttons and choose Assign macro,
choosing your code. If your buttons are from the Controls toolbar,
call your code from the Button_Click() event.
 
Back
Top