excel -can I use a text box as unprotected box in protected form.

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have a form for completion. The question boxes are protected, the answers
not.
In one case I need to allow as much as half a page of text for a reply and
do not seem to be able to get this using the format, merge cells function.
I thought that intriducind a text box would solve it, howver, the text box
is missed out when the sheet is protected and you tab through to answer the
questions in the form. How can i solve this problem please??? I am using
excel 2003 but would like it to work in excel 97 if possible.
 
Perhaps it would be better to create the form in Word, unless you need
Excel's calculation features in the form.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Text Box in Excel for noddy users! 6
Excel Protection 2
Unprotect Combo Box in a Protected Sheet 3
protect unprotect toggle VBA 6
How do I unprotect a text box in an otherwise protected worksheet 1
Excel Move or Copy Stopped Working? 0
Excel 2007 Text Boxes 3
Unprotect Sheet Box when saving 3

Back
Top