Jay thanks for your reply,

the textbox is embedded on a worksheet. when the textbox locked property is
set to true you can still enter text on a protected sheet!

An idea I tried late last night was toto prevent users from alteringthe text
in the textbox was to put another textbox over the top with the enabled
property = false locked = true and backstyle set to transparant. then the
user may clcik on area where text box is but cant att to Textbox 1. Not
ideal but does work

Paul

Jay wrote:
Have you tried setting the 'Locked' property of the textbox to True? You may
have to unlock it programmatically prior to filling it with a value...

UserForm1.TextBox1.Locked = True (or 'False' as needed).

I have searched long and hard for the solution to this problem.

[quoted text clipped - 22 lines]

thanks in advance

--
Message posted via OfficeKB.com
http://www.officekb.com/Uwe/Forums.a...mming/200611/1