Thread: how to make the content in an excel cell read only?!
View Single Post
  #6   Report Post  
Posted to microsoft.public.excel.programming
dm dm is offline
external usenet poster
  
Posts: 23
Default Use Data Validation
Select Cell
Data - Validation - Setttings - Validation Criteria - Select "Custom" -
in Formula enter "=" (equal sign)
That's it. Excel will not allow you to change value

Reply With QuoteReply With Quote