| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
How to determine button reference
My application copies a spreadsheet to create a second spreadsheet in the
same workbook, and massages the data in the second sheet. There are four buttons in the first sheet, and I wish to hide three of them in the second sheet. The button numbers of the first sheet change when they appear in the second sheet. How can I identify the buttons in the second sheet so as to hide them using the following statement: ActiveSheet.Shapes("Button X").visible = False -- Lon Sarnoff |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Maintaining cell reference after sorting | Excel Discussion (Misc queries) | |||
| Command Button anomalies | Excel Discussion (Misc queries) | |||
| RELATIVE REFERENCE BUTTON | Excel Discussion (Misc queries) | |||
| Command Button VBA code | Excel Discussion (Misc queries) | |||
| Macro to simply bring up the Find dialogue box?? | Excel Discussion (Misc queries) | |||
Threaded Mode
