Deleting option buttons
 

I've imported a column of option buttons with 4 columns data from the
internet. I can get rid of the data but the option buttons remain.
Nothing short of deleting the sheet will get rid of the option
buttons.

Help would be appreciated.

Joezy


--
jzemanek
------------------------------------------------------------------------
jzemanek's Profile: http://www.excelforum.com/member.php...o&userid=14632
View this thread: http://www.excelforum.com/showthread...hreadid=397378

Use the Drawing toolbar selector tool or use the Control Toolbox in design
view.
http://www.officearticles.com/misc/d...oft_office.htm
http://www.officearticles.com/misc/m...ica tions.htm
************
Anne Troy
www.OfficeArticles.com

"jzemanek" wrote in
message ...

I've imported a column of option buttons with 4 columns data from the
internet. I can get rid of the data but the option buttons remain.
Nothing short of deleting the sheet will get rid of the option
buttons.

Help would be appreciated.

Joezy


--
jzemanek
------------------------------------------------------------------------
jzemanek's Profile:
http://www.excelforum.com/member.php...o&userid=14632
View this thread: http://www.excelforum.com/showthread...hreadid=397378

To select all the objects on the sheet --
Choose EditGo To, click Special
Select Objects, click OK

Then, press the Delete key, to delete the selected objects.


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

Choose ToolsCustomize
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.
Press the Delete key, to delete the selected objects.


jzemanek wrote:
I've imported a column of option buttons with 4 columns data from the
internet. I can get rid of the data but the option buttons remain.
Nothing short of deleting the sheet will get rid of the option
buttons.

Help would be appreciated.

Joezy




--
Debra Dalgleish
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html