Unrestricted protected form

calvinbaisley · 09-15-2009, 06:03 PM

I have a form with 3 checkboxes that I wanted to be mutually exclusive (When one is checked the other 2 uncheck automatically). I found some VBA script online which does this nicely but the form has to be locked for it to work.
When I lock the form, I can edit the text on the page. The only thing I can change is the checkboxes. I have 2 lines of text at the top of the page which the user will have to change.
How can I free up just these 2 lines of text to allow editing but keep the rest protected so the checkboxes will work.

Thanks in advance

Greenw00d · 09-18-2009, 12:47 PM

Try looking at this tip:
http://excel.tips.net/Pages/T003078_...Worksheet.html

hope it helps

calvinbaisley · 09-19-2009, 06:52 AM

Thanks for your help.

I neglected to say in my post that I was having this problem with Word 2003 not Excel. Anyway, I found out that if I add a text box that any text in there can be edited even with the form protected so my problem is solved.

Regards

Calvin

09-15-2009, 06:03 PM	#1 (permalink)
calvinbaisley Registered User Join Date: Sep 2009 Posts: 2 OS: Vista	Unrestricted protected form I have a form with 3 checkboxes that I wanted to be mutually exclusive (When one is checked the other 2 uncheck automatically). I found some VBA script online which does this nicely but the form has to be locked for it to work. When I lock the form, I can edit the text on the page. The only thing I can change is the checkboxes. I have 2 lines of text at the top of the page which the user will have to change. How can I free up just these 2 lines of text to allow editing but keep the rest protected so the checkboxes will work. Thanks in advance

09-18-2009, 12:47 PM	#2 (permalink)
Greenw00d Registered User Join Date: Sep 2009 Posts: 1 OS: XP SP3	Re: Unrestricted protected form Try looking at this tip: http://excel.tips.net/Pages/T003078_...Worksheet.html hope it helps

09-19-2009, 06:52 AM	#3 (permalink)
calvinbaisley Registered User Join Date: Sep 2009 Posts: 2 OS: Vista	Re: Unrestricted protected form Thanks for your help. I neglected to say in my post that I was having this problem with Word 2003 not Excel. Anyway, I found out that if I add a text box that any text in there can be edited even with the form protected so my problem is solved. Regards Calvin