| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
invisible formulae
Hi All,
Theres a spreadsheet at work (by an author long since gone) which has lots of formulae in. When the sheet is protected the formulae are not shown in the formula bar, and only appear if you unprotect the sheet. How is this done? When I tried it in a new workbook the formulae were still visible, even though they couldn't be edited. |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
invisible formulae
Hi
'Format - Cells - Protection' and check the second checkbox -- Regards Frank Kabel Frankfurt, Germany Libby wrote: Hi All, Theres a spreadsheet at work (by an author long since gone) which has lots of formulae in. When the sheet is protected the formulae are not shown in the formula bar, and only appear if you unprotect the sheet. How is this done? When I tried it in a new workbook the formulae were still visible, even though they couldn't be edited. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Invisible Link | Excel Discussion (Misc queries) | |||
| Invisible sheets | Excel Discussion (Misc queries) | |||
| Formulae: Paste value formulae after doing an average operation | Excel Discussion (Misc queries) | |||
| Searching TEXT in formulae, rather than results of formulae | Excel Worksheet Functions | |||
| What is invisible in a cell?l | Excel Worksheet Functions | |||
Linear Mode
