Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Lock formulas from being edited
Helllo
I am working on a time sheet workbook for project every employee has his own sheet protected with a personnel password for daily data entry project The first sheet "Main "includes all the projects with a summary of total hours working for each project from all the employees all the other sheets are linked for this main sheet. Each employee need to unprotect his sheet with a personel password that only me and him knows about in order to make a data entry on daily basis concerning how many working hours on each project at the end you will find a total for the hours and a % of the working hours. The problem is that they are messing with my formulas by mistake so i cannot have the right calculation Is there is any way to protect those formulas from being edited and in the same keep a personel password for everysheet |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Lock formulas from being edited
Is there is any way to protect those formulas from being edited and in
the same keep a personel password for everysheet No. But you could unlock the cells they need to use and keep it locked all the time with a password they don't know. That is the typical method. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Lock formulas only not data | Excel Worksheet Functions | |||
lock only formulas, not worksheet | Excel Discussion (Misc queries) | |||
Lock formulas in a cell | Excel Discussion (Misc queries) | |||
Lock macro's from being edited | Excel Discussion (Misc queries) | |||
how do I lock certain cells from getting edited | New Users to Excel |