Text Box in Excel for noddy users!

[Anita]

I've created a 'form' in Excel (not using the form controls though) - and
protected the sheet so that only certain cells can be edited. However, I
have to create some areas for comments which need to behave like text boxes -
I tried merging cells but users seemed to mess up when completing the forms
so I thought I'd use a text box instead. I know how to protect the sheet and
leave the text box unprotected but the problem is that I don't want users to
be able to move or resize the text box. Any ideas gratefully received.
Thanks
Anita
PS - v2003

 

[Anita]

thanks that worked! how can i put a blue border round it?

 

[Anita]

thanks that worked! how can i put a blue border round it?

 

[Anita]

thanks that worked too! only thing is I've tested the text boxes and when I
press Enter it doesn't return down to the next line - nor does it wrap text -
I've set the enter key behaviour to true and wrap text - what am I doing
wrong? I've also exited design mode. Thanks for your help

 

[Anita]

thanks that worked too! only thing is I've tested the text boxes and when I
press Enter it doesn't return down to the next line - nor does it wrap text -
I've set the enter key behaviour to true and wrap text - what am I doing
wrong? I've also exited design mode. Thanks for your help

 

[Anita]

Found it ! multi line - last thing now I think - can I set a specific border
colour (RGB?) I need a specific shade of blue...

 

[Anita]

Found it ! multi line - last thing now I think - can I set a specific border
colour (RGB?) I need a specific shade of blue...