ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Command buttons etc (https://www.excelbanter.com/excel-programming/305242-command-buttons-etc.html)

timO

Command buttons etc
 
Hello All,

Is there a simple code to delete all Option buttons,
command buttons, etc from a worksheet.

Thanks

Stan Scott

Command buttons etc
 
Sub removeAll()
ActiveSheet.Shapes.SelectAll
Selection.Delete
End Sub

Stan Scott
New York City

"TimO" wrote in message
...
Hello All,

Is there a simple code to delete all Option buttons,
command buttons, etc from a worksheet.

Thanks





All times are GMT +1. The time now is 06:22 AM.

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