Good day everybody,

I use Excel to create a form for user to fill up.
There is a set of Option buttons which is for my own use where I want to
protect them from be select/change by user.
I have set the Format ControlProtectionLocked ticked. But after protect
worksheet, I can still select/change the Option buttons.
Can someone tell me how to protect the Option buttons?

Thanks in advance.

Have a nice day & Happy New Year.

Best regards,
Julie

Hi Julie-

Your option buttons should be protected. While the user
may be able to click the option buttons, they cannot alter
them and change the cell link. After 1 or 2 clicks, the
user should receive a protection message.

HTH
Jason
Atlanta, GA

-----Original Message-----
Good day everybody,

I use Excel to create a form for user to fill up.
There is a set of Option buttons which is for my own use
where I want to
protect them from be select/change by user.
I have set the Format ControlProtectionLocked ticked.
But after protect
worksheet, I can still select/change the Option buttons.
Can someone tell me how to protect the Option buttons?

Thanks in advance.

Have a nice day & Happy New Year.

Best regards,
Julie
.

Thanks Jason for your response.
However, the option buttons do change when they are click eventhough the
worksheet is protected.
Did I miss anything? I am using Excel 2002 (10.6501.6626) SP3.


"Jason Morin" wrote:

Hi Julie-

Your option buttons should be protected. While the user
may be able to click the option buttons, they cannot alter
them and change the cell link. After 1 or 2 clicks, the
user should receive a protection message.

HTH
Jason
Atlanta, GA

-----Original Message-----
Good day everybody,

I use Excel to create a form for user to fill up.
There is a set of Option buttons which is for my own use
where I want to
protect them from be select/change by user.
I have set the Format ControlProtectionLocked ticked.
But after protect
worksheet, I can still select/change the Option buttons.
Can someone tell me how to protect the Option buttons?

Thanks in advance.

Have a nice day & Happy New Year.

Best regards,
Julie
.