Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

How to remove a radio btn from an Excel sheet.

Status
Not open for further replies.

Goot

Programmer
Aug 4, 2005
86
US
I have an Excel sheet that was created by another user.
It has a series of radio buttons that I need to change to check boxes. Only thing is, how can I get the sheet into some kind of desinn mode to remove the radio button.
I have unprotected the sheet, then if I click the radio button, it gets enabled. So, how can I get to the design mode.
 
Goot,

How about
View -> Toolbars -> Control ToolBox
Click on the tool that looks like a draftsman's triangle with a pencil to toggle in and out of design mode.

Best,
W
 
Goot,

The method I described works if the button was created with the Control Toolbox Toolbar, but not if it was created with the Forms Toolbar. In the latter case, get the Select Objects tool from the Drawing Objects Toolbar, select the buttons by dragging a rectangle over them, and delete.

(Sorry, I just learned about the Forms tolbar on another thread!)

Walter
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top