Celeste,

Did you set the LockedText property along with the locked? For example:

Sub test()

With ActiveSheet.TextBoxes("Text Box 1")
.Locked = True
.LockedText = True
End With

End Sub

Note that the LockedText property is not available if you are referring to
the textbox as a member of Shapes, only when you access it through the
TextBoxes collection, as above.

hth,

Doug

"celeste " wrote in message
...
I have a spreadsheet with several text boxes that I do not want users to
edit. The text boxes are locked and the worksheet is protected.
However, users can still enter data into the locked text boxes. The
only remedy that I have found is to disable the text boxes, but I do
not like the grayed font that is displayed when a box is disabled.

Any help is appreciated,
Celeste


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