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

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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!
 
Hi Hubitron2000,

You could try selecting the top left of the sheet (to highlight the sheet),
edit, delete.
 
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 . . .
 
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.
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Cask beer being recognised by UNESCO as a UK intangable part of British life and its brewing and cultural history. i may not have said that very well 5
Excel How do I delete images in a specific range 1
Is there any formula like delete if? 4
getting rid of the "confirm delete" dialogue box when deleting a s 5
Deleting duplicate records 1
Select range then copy rows macro 1
Need to merge worksheets - Excel 2003 0
Multiple ranges with the same name 1

Back
Top