Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
locking formulas in Excel 2007 so users can't change but can vieworiginal formula?
Hi All:
Is there a way to lock formulas in Excel 2007 so users can't change but can view original formula? I can lock/protect a selected group of cells within a worksheet, but I wan't other users to be able to review the formulas from which the data is derived. Currently when you lock/ protect a group of cells, you can't see the formula. Grateful for your expertise! Verna |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
locking formulas in Excel 2007 so users can't change but can view original formula?
You can choose to hide the formula but by default it's set to not hide
formulas. Unprotect the sheet Select the cell(s) in question Right clickFormat CellsProtection tab Uncheck: Hidden OK Protect the sheet The formulas should now be visible. -- Biff Microsoft Excel MVP "Verna" wrote in message ... Hi All: Is there a way to lock formulas in Excel 2007 so users can't change but can view original formula? I can lock/protect a selected group of cells within a worksheet, but I wan't other users to be able to review the formulas from which the data is derived. Currently when you lock/ protect a group of cells, you can't see the formula. Grateful for your expertise! Verna |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Locking only one cell in Excel 2007 | Excel Discussion (Misc queries) | |||
How can I hide a formula in Excel 2007 from other users seeing it | Excel Discussion (Misc queries) | |||
How do I freeze a formula so other users can't change it? | Excel Discussion (Misc queries) | |||
excel 2007 file locking | Excel Discussion (Misc queries) | |||
Locking cells only for certain users | Excel Discussion (Misc queries) |