If linked to a cell, if both the cell and the control are locked and the
sheet and objects are protected (3 options under worksheet protection), then
it should resist being clicked on.

--
Regards,
Tom Ogilvy


"Julie" wrote in message
...
Good day everybody,

I have an entry form created using Excel XP. There are two sections in
this
form.
User 1 will fill the first section and protect the worksheet which will
protected the 1st section from being changed. This form will be send to
User
2 to fill the second section.
However, the option buttons in 1st section are still able to be click and
thus option is changed.
How do I protect the option button from being changed?
I was told it can't be done and have to use VBA. Can anyone guide me how
to?

Thank you in advance and have a nice day.

Best regards,
Julie