Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Can't get rid of a button
I have added a button to a sheet - now I want it gone.
However, for some reason, I can not highlight (or outline) the button. I can not get to a point to alter any properties for the button. Any ideas what I may have changed to prevent my access to it? The sheet and workbook are not protected. Thanks |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Can't get rid of a button
Do you have the sheet in design mode (display the control toolbox toolbar,
then click the upper left icon so it appears depressed - this assumes the button is from the control toolbox toolbar). To delete it you can try ActiveSheet.OleObjects(1).Delete if there is only one object on the worksheet - if not, you will need to figure out which one it is. -- Regards, Tom Ogilvy "jefe" wrote in message ... I have added a button to a sheet - now I want it gone. However, for some reason, I can not highlight (or outline) the button. I can not get to a point to alter any properties for the button. Any ideas what I may have changed to prevent my access to it? The sheet and workbook are not protected. Thanks |
Reply |
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) | |||
Command Button vs Form Button | Excel Programming |