View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Novice
 
Posts: n/a
Default 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!