View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.worksheet.functions
tgodrich tgodrich is offline
external usenet poster
 
Posts: 3
Default when I protect a worksheet, user cannot use check boxes

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.

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