Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Making code accessible to many buttons
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. |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Making code accessible to many buttons
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. In article , "S. S." wrote: 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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
form option buttons - how can I make them accessible? | Excel Discussion (Misc queries) | |||
Making A Code | Excel Worksheet Functions | |||
making switchboards and linking buttons in excel | New Users to Excel | |||
Making Excel accessible on our server | Excel Discussion (Misc queries) | |||
Making Command Buttons | Excel Programming |