Can't get rid of a button

J

jefe

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
 
T

Tom Ogilvy

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.
 
Top