| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Viewing Formulas in Locked Cells
Hello-
I am trying to figure out how I can set a preference on the locked cells. I want the 'user' to be able to look at the formula in the cell when you click on it, but NOT to be able to make any changes on it. I didn't see this as an option when I was locking the cells. Any ideas? Thanks in advance! Stacy |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Viewing Formulas in Locked Cells
Unprotect worksheet/workbook
Mark cell with formula as locked, but not hidden Protect worksheeet, allowing users to select both locked and unlocked cells -- Gary''s Student - gsnu200760 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Is there any way of viewing the formula of a locked cell? | Excel Worksheet Functions | |||
| Put comments on a locked spreadsheet even though cells not locked | Excel Worksheet Functions | |||
| viewing formulas | Excel Discussion (Misc queries) | |||
| Viewing LOCKED cells | Excel Discussion (Misc queries) | |||
| Excel 2003 when closing Excel after having opened a project locked for viewing.. password prompt??? | Excel Discussion (Misc queries) | |||
Linear Mode
