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

have you protected the objects on the worksheet? sheet protection has three
areas that can be protected.

--
Regards,
Tom Ogilvy

"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/