| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Multiple Command button programming
I have a workbook with 5 spreadsheets in it. Each sheet has a series
of command buttons. CommandButton1 in each sheet deletes the contents of that worksheet. I would like to program a general command button in the first spreadsheet that deletes the contents of all the sheets in the workbook by activating commandbutton1 in each spreadsheet. Is this possible thank you |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Multiple Command button programming
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 -- HTH... Jim Thomlinson "Good Time" wrote: I have a workbook with 5 spreadsheets in it. Each sheet has a series of command buttons. CommandButton1 in each sheet deletes the contents of that worksheet. I would like to program a general command button in the first spreadsheet that deletes the contents of all the sheets in the workbook by activating commandbutton1 in each spreadsheet. Is this possible thank you |
|
#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 |
| Reply |
| 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 | |||
Linear Mode
