The same applies!, either that or specifically name them in an intersect
range, and make it so that cell cannot be selected, but of course if you
are doing that macro's have to be enabled!

NA_AB;189924 Wrote:
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' ('The Code Cage' (http://www.thecodecage.com))

------------------------------------------------------------------------
Simon Lloyd's Profile: 'The Code Cage Forums - View Profile: Simon
Lloyd' (http://www.thecodecage.com/forumz/member.php?userid=1)
View this thread: 'how to make the content in an excel cell read
only?! - The Code Cage Forums'
(http://www.thecodecage.com/forumz/sh...ad.php?t=52319)




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