View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Michael.Tarnowski Michael.Tarnowski is offline
external usenet poster
 
Posts: 95
Default Preventing user input for individual cells

Hi community,
I'am working with Excel 2003 and I'am wondering how to prevent user
inputs for individuals cells without locking the whole sheet. For
example, if Row B contains cells displaying formula results - dates,
numbers, or text - the user should not be able to change cells in B.
How can I achive this? - With Data validations?

Thanks and cheers
Michael