View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.programming
NA_AB[_2_] NA_AB[_2_] is offline
external usenet poster
 
Posts: 57
Default how to make the content in an excel cell read only?!

well, am actually working with c# and developing an excel addin. I need to
make some excel cells, having some text, read-only and the rest of the sheet
is free to any modifications by the user.

Regards.

"Simon Lloyd" wrote:


*how to make the content in an excel cell read only?!* Firstly you have to make sure the cells attributes are locked (right

click, format cells, protection) they are locked by default, then
protect the sheet, the cell can then only be read not edited. To be
honest you need to explain more what you want to do!


--
Simon Lloyd

Regards,
Simon Lloyd
'The Code Cage' (http://www.thecodecage.com)
------------------------------------------------------------------------
Simon Lloyd's Profile: http://www.thecodecage.com/forumz/member.php?userid=1
View this thread: http://www.thecodecage.com/forumz/sh...ad.php?t=52319