View Single Post
  #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