![]() |
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 |
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