Click to Reset Radio Button

[dgold82]

I have a number of control groups on a worksheet with radio buttons in them
(looks like a scantron). If I locked the worksheet is there a way for a user
to reset a radio button by just clicking again on it without having to "right
click" and click on
"clear contents". I ask because I will be disabling all the command bars and
right click ability through VBA. Any help would be appreciated.

 

[Dave Peterson]

Check your other post.

I have a number of control groups on a worksheet with radio buttons in them
(looks like a scantron). If I locked the worksheet is there a way for a user
to reset a radio button by just clicking again on it without having to "right
click" and click on
"clear contents". I ask because I will be disabling all the command bars and
right click ability through VBA. Any help would be appreciated.

 

[haali]

Check your other post.

Dave:

I don't know how you are locking the sheet. Are you protecting the
sorksheet? Or the workbook? Are you using a password?

Once I know this I may be able to help.

Hyder Ali

 

[Dave Peterson]

I'm not the person who posted the question.

Dave:

I don't know how you are locking the sheet. Are you protecting the
sorksheet? Or the workbook? Are you using a password?

Once I know this I may be able to help.

Hyder Ali

 

[dgold82]

Hi Hyder. See this discussion:
http://www.microsoft.com/office/com...&p=1&tid=517464e7-fe67-4e9b-8197-234e01651037

I am locking the worksheet and workbook. Cells that are linked to the radio
buttons are unlocked and hidden. Thanks.