Control toolbox objects

D

Dan

I have created a template that has combo boxes and radio
buttons on most rows.

When I try and delete the bottom row, the row deletes, but
the combo and radio remain. I have tried cutting them and
deleting them or moving them, but nothing helps.

I have tried in Excel 2003 and 2002.

Help.
 
B

Bob Phillips

That is because they are not on the worksheet but 'above' it. Select them
individually and delete them.

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)
 
D

Dan

Thanks, but that doesn't work.

I have tried selecting them individually so that I get a
circle in each corner of the object and then deleting them
to no avail. If I try moving them it creates a copy and
leaves the problematic one in the original place

Any other ideas?

thanks
 
D

Debra Dalgleish

There may be multiple combo boxes and radio buttons in each row. When
you drag one away, it reveals the next object in the stack.

To test this --
On the Drawing toolbar, click on the 'Select Objects' tool
On the worksheet, use the 'Select Objects' tool to draw a rectangle
around one of the combo boxes.
Press the Delete key.

Or, if you want to delete all the objects on the sheet --
Choose Edit>Go To, click Special
Select Objects, click OK
Press the Delete key, to delete any objects that were selected.

Or, to work with specific objects, you can add the 'Select Multiple
Objects' tool to one of your toolbars:

Choose Tools>Customize
Select the Commands tab
Select the Drawing Category
Drag the 'Select Multiple Objects' tool onto one of your toolbars
Click Close

Then, click the Select Multiple Objects button, and select any or all
objects on the worksheet.
 
Top