ExcelBanter - Select All controls in a worksheet and delete them

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - Select All controls in a worksheet and delete them (https://www.excelbanter.com/excel-discussion-misc-queries/24079-select-all-controls-worksheet-delete-them.html)

rova78

Select All controls in a worksheet and delete them

I copy information from an internet interface. The information contains
controls. (usually check boxes) I would like to select all of these controls
on the sheet and delete them.

Solve my problem and make my day.

Thanks,

Ron de Bruin

Hi

F5
Special
Objects
OK
Press the Delete key

--
Regards Ron de Bruin
http://www.rondebruin.nl

"rova78" wrote in message ...
I copy information from an internet interface. The information contains
controls. (usually check boxes) I would like to select all of these controls
on the sheet and delete them.

Solve my problem and make my day.

Thanks,

All times are GMT +1. The time now is 03:15 PM.