ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Can't get rid of a button (https://www.excelbanter.com/excel-programming/293081-cant-get-rid-button.html)

jefe

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

Tom Ogilvy

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





All times are GMT +1. The time now is 05:31 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com