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

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!

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

Maybe...
Edit|goto|special|check objects
hit the delete key



Hubitron2000 wrote:

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!

--

Dave Peterson

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

Hi Hubitron2000,

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

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

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 . . .

"Dave Peterson" wrote:

Maybe...
Edit|goto|special|check objects
hit the delete key



Hubitron2000 wrote:

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!

--

Dave Peterson
.

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

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.

Hubitron2000 wrote:

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 . . .

"Dave Peterson" wrote:

Maybe...
Edit|goto|special|check objects
hit the delete key



Hubitron2000 wrote:

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!

--

Dave Peterson
.


--

Dave Peterson