View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
ndalal ndalal is offline
external usenet poster
 
Posts: 17
Default how to make cell read only

Hi,

I have tried the following code, but doesn't work unless I protect the
sheet:
Range("A1:A4").Select
Selection.Locked = True
Selection.FormulaHidden = False

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

Any help is appreciated.

Thanks.