Is there a quick way to delete all the controls in a range?

H

Hubitron2000

I've got thousands and thousands of controls in a worksheet, and I need to
delete them all. How can I select them all at once and remove them from the
sheet?

Thanks!
 
B

BigPig

Hi Hubitron2000,

You could try selecting the top left of the sheet (to highlight the sheet),
edit, delete.
 
H

Hubitron2000

That did it, thanks!

Bonus question: can I only "go to" the controls in a specific range?

I tried highlighting a selection first, but that didn't work . . .
 
D

Dave Peterson

You can show the drawing tool.

It has an arrow icon that you can use to lasso the controls that you want.

If the controls are from the control toolbox toolbar (activeX controls), you may
need to show that control toolbox toolbar and go into design mode first.

You could also customize a toolbar with:

Tools|Customize|commands tab|Drawing category
And drag the select multiple objects icon to your favorite toolbar
(and maybe drag that select objects icon, too?)

You'll see a dialog that you can pick and choose.
 
Top