View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Don Guillett[_4_] Don Guillett[_4_] is offline
external usenet poster
 
Posts: 2,337
Default Greying out(disabling) textbox from being typed in

In properties the default is locked which will take effect upon protecting
the sheet.

--
Don Guillett
SalesAid Software

"Todd Huttenstine" wrote in message
...
How do you Grey out(disable) a textbox from being typed
in? I have Textbox1 display the value of a cell on the
spreadsheet but I dont want the user to be able to click
and type in the textbox. What would the code be for this?


Thank you
Todd Huttenstine