Technically you can't, but depending on your needs you can do something
as follows, where "F7" is the cell you want protected:

Private Sub Worksheet_Change(ByVal Target As Range)
Range("F7").Value = "Your Formula or Text Goes Here"
End Sub

Harald Staff Wrote:
You can't, sorry.

Best wishes Harald

"ndalal" skrev i melding
ups.com...

If I protect the sheet, then it works fine, but how can I make a
cell
read only
WITHOUT protecting the sheet ??


--
Ikaabod
------------------------------------------------------------------------
Ikaabod's Profile: http://www.excelforum.com/member.php...o&userid=33371
View this thread: http://www.excelforum.com/showthread...hreadid=540414