I did a bit more digging into this and found the problem. I had the radio
buttons linked to a cell way out of view on the worksheet. This cell WAS
locked. The second worksheet actually contains a link to the hidden cell on
the first worksheet. Anyway, thanks for the help. It got me pointed in the
right direction. I am basically setting up an Excel form, with a hidden
worksheet that has all data fields on one line, so that I can import into
Access automatically with pre-named fields that match those in Access.

"Johnathan" wrote:

Probably the error is due to the locked status of the cell linked to the
checkbox.
You are probably using the check box from the Developer Tab, in this case
you can find the linked cell by right clicking the control, select "Format
control" on the pop-up menu, and activate the tab "protection". Here there
is an option to unlock the control.
Then you should be able to protect the worksheet and use the check box.

"tgodrich" wrote:

When I protect my excel worksheet, my radio buttons and my check boxes are
protected and the form users cannot edit them. The properties are unlocked
for these controls, but that does not seem to have any effect. All other
fields in the worksheet that are not buttons or check boxes work correctly
and allow data entry.