when I protect a worksheet, user cannot use check boxes


T

tgodrich

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.
 
Ad

Advertisements

J

Johnathan

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.
 
S

Shane Devenshire

Hi,

With protection off, right click the check box and choose Format Control,
Protection and uncheck Locked.
 
T

tgodrich

The linked cell and the worksheet it is on are unlocked and unprotected
respectively. The radio buttons are all unlocked, as well as the cells
behind them. Only the worksheet containing the form is protected. The check
boxes (there are 4) work fine when the form worksheet is unprotected. The
linked cell contains an "If" statement to determine which of the radio boxes
is checked and enter the appropriate text to correlate. I need to protect
the worksheet to stop users from modifying the form.
 
Ad

Advertisements

T

tgodrich

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top