Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
how to activate controls in protected sheet
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! |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
how to activate controls in protected sheet
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 |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
how to activate controls in protected sheet
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
AutoFilter 2003 Excel Protected Sheet | Excel Discussion (Misc queries) | |||
Protected Sheet Message | Excel Discussion (Misc queries) | |||
Applying autofilter to protected sheet | Excel Discussion (Misc queries) | |||
Copying multiple sheets from one book 2 another and undertake spec | Excel Discussion (Misc queries) | |||
Unable to open excel sheet in Protected mode from VB 6.0 | Setting up and Configuration of Excel |