Celeste,

Ah ha. Yes, it looks to me like locking a textbox from the Controls Toolbox
means you can't manipulate it even in design mode. I don't see any way of
locking the actual text in it.

If you want to use something from the Controls Toolbox and not have it
changed by a user, would a label work?

Doug

"celeste " wrote in message
...
The text boxes that I am using are not drawing objects. They are active
X objects. I think that's why that code that Doug suggested does not
work.

Celeste


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