| Home |
| Search |
| Today's Posts |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Multiple Command button programming - Thank you I'll try this.
On Thu, 14 Sep 2006 16:35:01 -0700, Jim Thomlinson
wrote: so you have Private CommandButton1_Click() Change that to Public CommandButton1_Click() And now you can call it from other sheets or modules something like this Sheet1.CommandButton1_Click or Sheets("mysheet").CommandButton1_Click |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| set up a command button to print multiple workbook | Excel Discussion (Misc queries) | |||
| Counting, command button and programming in VB | Excel Discussion (Misc queries) | |||
| Programming a "Save as..." command button within Excel | Excel Discussion (Misc queries) | |||
| Refresh Multiple Queries via a Command Button | Excel Programming | |||
| Programming command button to execute on a different worksheet | Excel Programming | |||
Threaded Mode
