A Microsoft Office (Excel, Word) forum. OfficeFrustration

If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

Go Back   Home » OfficeFrustration forum » Microsoft Excel » General Discussion
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

Text Box in Excel for noddy users!



 
 
Thread Tools Display Modes
  #1  
Old May 13th, 2009, 09:22 PM posted to microsoft.public.excel.misc
Anita
external usenet poster
 
Posts: 202
Default Text Box in Excel for noddy users!

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
  #2  
Old May 14th, 2009, 01:04 AM posted to microsoft.public.excel.misc
Simon Lloyd[_248_]
external usenet poster
 
Posts: 1
Default Text Box in Excel for noddy users!


Thats odd, once you place a textbox from the controls toolbox on a
worksheet it cannot be moved or resized unless you have left it in
design mode, if this is the case, go back to VIEWTOOLBARSCONTROLS
TOOLBOX and click the icon in the top left hand corner of the toolbox,
this toggles design mode.

Anita;344369 Wrote:
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



--
Simon Lloyd

Regards,
Simon Lloyd
'The Code Cage' (http://www.thecodecage.com)
------------------------------------------------------------------------
Simon Lloyd's Profile: http://www.thecodecage.com/forumz/member.php?userid=1
View this thread: http://www.thecodecage.com/forumz/sh...ad.php?t=96352

  #3  
Old May 17th, 2009, 11:47 AM posted to microsoft.public.excel.misc
Anita
external usenet poster
 
Posts: 202
Default Text Box in Excel for noddy users!

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

"Simon Lloyd" wrote:


Thats odd, once you place a textbox from the controls toolbox on a
worksheet it cannot be moved or resized unless you have left it in
design mode, if this is the case, go back to VIEWTOOLBARSCONTROLS
TOOLBOX and click the icon in the top left hand corner of the toolbox,
this toggles design mode.

Anita;344369 Wrote:
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



--
Simon Lloyd

Regards,
Simon Lloyd
'The Code Cage' (http://www.thecodecage.com)
------------------------------------------------------------------------
Simon Lloyd's Profile: http://www.thecodecage.com/forumz/member.php?userid=1
View this thread: http://www.thecodecage.com/forumz/sh...ad.php?t=96352


  #4  
Old May 17th, 2009, 12:54 PM posted to microsoft.public.excel.misc
Simon Lloyd[_258_]
external usenet poster
 
Posts: 1
Default Text Box in Excel for noddy users!


With the same toolbox you have just used, do the opposite of my previous
mail, then click the textbox once, then on the toolbox xlixk the
poperties icon next to the design mode icon you will then see a whole
host of things that you can do with the textbox including borders and
styles!

Anita;348347 Wrote:
thanks that worked! how can i put a blue border round it?

"Simon Lloyd" wrote:


Thats odd, once you place a textbox from the controls toolbox on a
worksheet it cannot be moved or resized unless you have left it in
design mode, if this is the case, go back to VIEWTOOLBARSCONTROLS
TOOLBOX and click the icon in the top left hand corner of the

toolbox,
this toggles design mode.

Anita;344369 Wrote:
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



--
Simon Lloyd

Regards,
Simon Lloyd
'The Code Cage' ('The Code Cage' (http://www.thecodecage.com))

------------------------------------------------------------------------
Simon Lloyd's Profile: 'The Code Cage Forums - View Profile: Simon

Lloyd' (http://www.thecodecage.com/forumz/member.php?userid=1)
View this thread: 'Text Box in Excel for noddy users! - The Code Cage

Forums' (http://www.thecodecage.com/forumz/sh...ad.php?t=96352)




--
Simon Lloyd

Regards,
Simon Lloyd
'The Code Cage' (http://www.thecodecage.com)
------------------------------------------------------------------------
Simon Lloyd's Profile: http://www.thecodecage.com/forumz/member.php?userid=1
View this thread: http://www.thecodecage.com/forumz/sh...ad.php?t=96352

  #5  
Old May 17th, 2009, 03:04 PM posted to microsoft.public.excel.misc
Anita
external usenet poster
 
Posts: 202
Default Text Box in Excel for noddy users!

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

"Simon Lloyd" wrote:


With the same toolbox you have just used, do the opposite of my previous
mail, then click the textbox once, then on the toolbox xlixk the
poperties icon next to the design mode icon you will then see a whole
host of things that you can do with the textbox including borders and
styles!

Anita;348347 Wrote:
thanks that worked! how can i put a blue border round it?

"Simon Lloyd" wrote:


Thats odd, once you place a textbox from the controls toolbox on a
worksheet it cannot be moved or resized unless you have left it in
design mode, if this is the case, go back to VIEWTOOLBARSCONTROLS
TOOLBOX and click the icon in the top left hand corner of the

toolbox,
this toggles design mode.

Anita;344369 Wrote:
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


--
Simon Lloyd

Regards,
Simon Lloyd
'The Code Cage' ('The Code Cage' (http://www.thecodecage.com))

------------------------------------------------------------------------
Simon Lloyd's Profile: 'The Code Cage Forums - View Profile: Simon

Lloyd' (http://www.thecodecage.com/forumz/member.php?userid=1)
View this thread: 'Text Box in Excel for noddy users! - The Code Cage

Forums' (http://www.thecodecage.com/forumz/sh...ad.php?t=96352)




--
Simon Lloyd

Regards,
Simon Lloyd
'The Code Cage' (http://www.thecodecage.com)
------------------------------------------------------------------------
Simon Lloyd's Profile: http://www.thecodecage.com/forumz/member.php?userid=1
View this thread: http://www.thecodecage.com/forumz/sh...ad.php?t=96352


  #6  
Old May 17th, 2009, 03:08 PM posted to microsoft.public.excel.misc
Anita
external usenet poster
 
Posts: 202
Default Text Box in Excel for noddy users!

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

"Simon Lloyd" wrote:


With the same toolbox you have just used, do the opposite of my previous
mail, then click the textbox once, then on the toolbox xlixk the
poperties icon next to the design mode icon you will then see a whole
host of things that you can do with the textbox including borders and
styles!

Anita;348347 Wrote:
thanks that worked! how can i put a blue border round it?

"Simon Lloyd" wrote:


Thats odd, once you place a textbox from the controls toolbox on a
worksheet it cannot be moved or resized unless you have left it in
design mode, if this is the case, go back to VIEWTOOLBARSCONTROLS
TOOLBOX and click the icon in the top left hand corner of the

toolbox,
this toggles design mode.

Anita;344369 Wrote:
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


--
Simon Lloyd

Regards,
Simon Lloyd
'The Code Cage' ('The Code Cage' (http://www.thecodecage.com))

------------------------------------------------------------------------
Simon Lloyd's Profile: 'The Code Cage Forums - View Profile: Simon

Lloyd' (http://www.thecodecage.com/forumz/member.php?userid=1)
View this thread: 'Text Box in Excel for noddy users! - The Code Cage

Forums' (http://www.thecodecage.com/forumz/sh...ad.php?t=96352)




--
Simon Lloyd

Regards,
Simon Lloyd
'The Code Cage' (http://www.thecodecage.com)
------------------------------------------------------------------------
Simon Lloyd's Profile: http://www.thecodecage.com/forumz/member.php?userid=1
View this thread: http://www.thecodecage.com/forumz/sh...ad.php?t=96352


 




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump


All times are GMT +1. The time now is 10:11 PM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 OfficeFrustration.
The comments are property of their posters.