View Single Post
  #8   Report Post  
Posted to microsoft.public.excel.programming
Tom Ogilvy Tom Ogilvy is offline
external usenet poster
 
Posts: 27,285
Default Cannot Lock Text Boxes-Excel 2002

Sounds like you are using a textbox from the control toolbox toolbar.
Recommend you use a label and change the SpecialEffect property to
fmSpecialEffectSunken (2). This makes the label look just like a textbox,
the text will be bright and it can't be edited.

--
Regards,
Tom Ogilvy


"celeste " wrote in message
...
Doug,
I tried your code and got "Object does not support this property or
method"

Celeste


---
Message posted from http://www.ExcelForum.com/