Option Box Protected

[Whois Clinton]

I have option boxes from the "Forms" toolbar. On the sheet there are some
cells with formulas I would like protected. When I protect the sheet a
couple of things go wrong:

1. Everytime I click an option box the cell protected box pops up. I have
tried unlocking the cells the traditional way, as well as unlocking the
option box Format control. This problem persists.

2. The option box groupings misfunction. Usually I can only select one in
a group at a time. Once protected several can be selected and some
selections cause other option box to change with them.

Neither of these problems occur when the sheet is unprotected.

Any ideas would be greatly appreciated.
THanks,
Clint

 

[ShaneDevenshire]

Hi,

Try this it might work. The option buttons feed a linked cell. You can see
where that is by right-clicking the Option Button and choosing Format
Control, Control tab and noting the Cell Link box. That is the cell in the
spreadsheet which must be unlocked. Select the Link Cell in the spreadsheet
and choose Format, Cells, Protection, and uncheck Locked.
Then turn on protection, Tools, Protection, Protect Sheet, OK.

Click the option button.

 

[Whois Clinton]

Thanks that was exactly my mistake.

Hi,

Try this it might work. The option buttons feed a linked cell. You can see
where that is by right-clicking the Option Button and choosing Format
Control, Control tab and noting the Cell Link box. That is the cell in the
spreadsheet which must be unlocked. Select the Link Cell in the spreadsheet
and choose Format, Cells, Protection, and uncheck Locked.
Then turn on protection, Tools, Protection, Protect Sheet, OK.

Click the option button.