how to activate controls in protected sheet

[Novice]

I am doing a survey form in Excel2003 with 100+ option buttons and a "submit"
button. After I protect the sheet by tools\protect sheet..., the 'submit'
botton still works, but all my 100+ radio buttons cannot be changed/click
(message appear asking user to unprotect sheet). I already used "tools\allow
users to edit..." to release all cells linked to the radio buttons

Did I do anything wrong? Is there any way to protect the sheet but still
keep my radio buttons alive?

thanks a million!

[Dave Peterson]

Did you link to cells that are locked on a protected worksheet?

You'll have to unlock those cells.

Novice wrote:
>
> I am doing a survey form in Excel2003 with 100+ option buttons and a "submit"
> button. After I protect the sheet by tools\protect sheet..., the 'submit'
> botton still works, but all my 100+ radio buttons cannot be changed/click
> (message appear asking user to unprotect sheet). I already used "tools\allow
> users to edit..." to release all cells linked to the radio buttons
>
> Did I do anything wrong? Is there any way to protect the sheet but still
> keep my radio buttons alive?
>
> thanks a million!

--

Dave Peterson

[Novice]

Thanks Dave. I did what your said and it works! Thanks a million!

"Dave Peterson" wrote:

> Did you link to cells that are locked on a protected worksheet?
>
> You'll have to unlock those cells.
>
> Novice wrote:
> >
> > I am doing a survey form in Excel2003 with 100+ option buttons and a "submit"
> > button. After I protect the sheet by tools\protect sheet..., the 'submit'
> > botton still works, but all my 100+ radio buttons cannot be changed/click
> > (message appear asking user to unprotect sheet). I already used "tools\allow
> > users to edit..." to release all cells linked to the radio buttons
> >
> > Did I do anything wrong? Is there any way to protect the sheet but still
> > keep my radio buttons alive?
> >
> > thanks a million!
>
> --
>
> Dave Peterson
>