View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
MedTech MedTech is offline
external usenet poster
 
Posts: 10
Default protecting individual cells

hopefully I stopped my first posting, if not I am sorry.
We use a formatted worksheet for a couple of our tests values. We use the
same formatted worksheets daily, and just save them under a new name. We have
had a few techs change the quality control values and some of the conditional
formatting, that should not have access to this (causes a lot of correction
for us). I would like to password protect just those certain cells and allow
access only for myself and my supervisor to prevent this. How can one
password protect just certain cells and allow other cells to have information
imputted into them. We are using Excel 2003