S
Sue N.
I have a form that will be completed by several users, so I have
protected the worksheet to keep the formatting and formulas from
corruption. Cells requiring input have been unlocked as needed. Part
of the form requires a narrative, so I have inserted text boxes to
allow narrative that wraps and allows new paragraphs. When protecting
the worksheet, I unchecked Objects to allow typing in the text boxes.
I have 2 questions:
1. Is there a way to allow spell check on the narrative if the sheet
is protected. If so, how?
2. Is there a way to restrict the size of the text box to fit on the
form? Otherwise as you type the text will scroll and not all of the
text will show on the screen or printed version.
Thank you!
Sue
protected the worksheet to keep the formatting and formulas from
corruption. Cells requiring input have been unlocked as needed. Part
of the form requires a narrative, so I have inserted text boxes to
allow narrative that wraps and allows new paragraphs. When protecting
the worksheet, I unchecked Objects to allow typing in the text boxes.
I have 2 questions:
1. Is there a way to allow spell check on the narrative if the sheet
is protected. If so, how?
2. Is there a way to restrict the size of the text box to fit on the
form? Otherwise as you type the text will scroll and not all of the
text will show on the screen or printed version.
Thank you!
Sue