| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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!!! |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| need to lock 5 cells but not protect entire sheet | Excel Discussion (Misc queries) | |||
| How do I lock/protect cells so they can't be changed | Excel Worksheet Functions | |||
| how do I protect formula's only, not entire sheet or book? | Setting up and Configuration of Excel | |||
| Protect/Lock Specific Cells | Excel Discussion (Misc queries) | |||
| Can I use the grouping and lock and protect cells | Excel Discussion (Misc queries) | |||
Threaded Mode
