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.

Check your other post.

dgold82 wrote:

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

On Apr 26, 6:48*pm, Dave Peterson wrote:
Check your other post.

dgold82 wrote:

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

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

I'm not the person who posted the question.

wrote:

On Apr 26, 6:48 pm, Dave Peterson wrote:
Check your other post.

dgold82 wrote:

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

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

Hi Hyder. See this discussion:
http://www.microsoft.com/office/comm...7-234e01651037

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

" wrote:

On Apr 26, 6:48 pm, Dave Peterson wrote:
Check your other post.

dgold82 wrote:

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

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