| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Finding a button
During a macro, if there is a "Button" on the activesheet,
I would like to delete it. Activesheet.Shapes("Button 1").Cut will get rid of it, but sometimes the macro is run a second time and then there is no button to cut and I get an error message. Is there an IF statement to find shapes? TIA, Brad E. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Undo button and redo button quit | Excel Discussion (Misc queries) | |||
| Inserting a Graphic on a Button when the Button is Assigned to a M | Excel Discussion (Misc queries) | |||
| insert row above button (retrieve position of button) | Excel Discussion (Misc queries) | |||
| How do I lock a radio button group if a N/A button is selected | Excel Discussion (Misc queries) | |||
| Delete a custom button by holding down the ALT key and dragging the button off the toolbar | Excel Programming | |||
Threaded Mode
