Can't get rid of a button

  • Thread starter Thread starter jefe
  • Start date Start date
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
 
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.
 
Back
Top