PSL
01-06-2011, 10:46 AM
Greeting,
I am facing a very tedious problem that can be done manually but am hoping it could be done with the help of a macro.
I have created a survey with various Option Buttons, Checkboxes and have merged cells to create spaces where respondents can enter subjective information.
Now, before floating this survey I need to password protect it to ensure that the options are not fiddled with. While protecting the sheet I am intending to allow to respondents to be able to edit unlocked cells. Therefore I would be required to unlock the cell where all the checkboxes and option buttons are linked. And also the cells I have merged to give space for subjective answers.
Now this can be done manually ofcourse. But due to the size of the survey that would take hours to say the least.
Was hoping someone could help. Have attached a sample file.
Regards,
I am facing a very tedious problem that can be done manually but am hoping it could be done with the help of a macro.
I have created a survey with various Option Buttons, Checkboxes and have merged cells to create spaces where respondents can enter subjective information.
Now, before floating this survey I need to password protect it to ensure that the options are not fiddled with. While protecting the sheet I am intending to allow to respondents to be able to edit unlocked cells. Therefore I would be required to unlock the cell where all the checkboxes and option buttons are linked. And also the cells I have merged to give space for subjective answers.
Now this can be done manually ofcourse. But due to the size of the survey that would take hours to say the least.
Was hoping someone could help. Have attached a sample file.
Regards,