View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
J. Becker J. Becker is offline
external usenet poster
 
Posts: 1
Default How can I lock specific cells w/o having to protect entire sheet?

I have designed a worksheet so my boss can enter data from time cards and get
the total hours worked each week by each employee. However, there are
certain cells I don't want anyone to have access to because they must not be
changed, or the worksheet won't do what is needed. So, how do I lock
specific cells only. I want him to be able to use the worksheet to input the
time data, but not access the cells that do the computing because he is not
very computer oriented. Help!!!