Reply
 
Thread Tools Display Modes
  #1   Report Post  
Posted to microsoft.public.word.docmanagement
Conditional Formatting
 
Posts: n/a
Default Protect sheet with check boxes

we are creating some XLS forms (for people to fill-in) with simple check
boxes etc...

I need these forms to be totally protected (cells should not even be
selectable) except very few ones where TEXT should be typed and the radio
buttons and check boxes. When using the standard sheet protection from +XLS,
I get all kind of warning when using the check boxes etc... do you know how
to protect without getting the warnings? We want the other area to remain
fillable only (plus the check boxes and radio button). Currently these two
type of cells are set on "unlocked" .

What should we do in order not to have WARNING when we protect the file?

Many thanks,
NIE

  #2   Report Post  
Posted to microsoft.public.word.docmanagement
Charles Kenyon
 
Posts: n/a
Default Protect sheet with check boxes

xls forms are Excel, not Word. In Word this would be what is called an
"online form." Check this in help. For more about online forms, follow the
links at http://addbalance.com/word/wordwebresources.htm#Forms or
http://word.mvps.org/FAQs/Customizat...nTheBlanks.htm especially Dian
Chapman's series of articles. You may also want to look at
http://www.word.mvps.org/FAQs/TblsFl...nesInForms.htm.

Hope this helps,
--

Charles Kenyon

Word New User FAQ & Web Directory: http://addbalance.com/word

Intermediate User's Guide to Microsoft Word (supplemented version of
Microsoft's Legal Users' Guide) http://addbalance.com/usersguide

See also the MVP FAQ: http://word.mvps.org/FAQs/ which is awesome!
--------- --------- --------- --------- --------- ---------
This message is posted to a newsgroup. Please post replies
and questions to the newsgroup so that others can learn
from my ignorance and your wisdom.
"Conditional Formatting"
wrote in message ...
we are creating some XLS forms (for people to fill-in) with simple check
boxes etc...

I need these forms to be totally protected (cells should not even be
selectable) except very few ones where TEXT should be typed and the radio
buttons and check boxes. When using the standard sheet protection from
+XLS,
I get all kind of warning when using the check boxes etc... do you know
how
to protect without getting the warnings? We want the other area to remain
fillable only (plus the check boxes and radio button). Currently these two
type of cells are set on "unlocked" .

What should we do in order not to have WARNING when we protect the file?

Many thanks,
NIE



Reply
Thread Tools
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
check boxes that disappear Kathy Microsoft Word Help 0 November 9th 05 03:17 PM
Make check boxes mutually exclusive JH Microsoft Word Help 2 September 26th 05 04:53 PM
check boxes in Word 2000 Marcel Microsoft Word Help 3 June 23rd 05 03:07 PM
How do I align check boxes with the text that comes before it/ keithmichaelis Microsoft Word Help 6 May 9th 05 04:28 PM
check boxes Pam119 Tables 1 April 26th 05 09:28 PM


All times are GMT +1. The time now is 08:29 AM.

Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 Microsoft Office Word Forum - WordBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Word"