How to remove a radio btn from an Excel sheet.

[Goot]

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.

 

[WalterContrata]

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]

Thank you, I will try it.

 

[BlueHorizon]

Hi,
I've had some success with right-clicking it first so it gets the box around it, then click once on the box and use your delete key.
HTH,

Best,
Blue Horizon

http://www.bluehorizontraining.com

 

[WalterContrata]

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