Home |
Search |
Today's Posts |
|
#1
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
Hi,
you have to protect the worksheet so all the cells locked will not be available to the users To unlock the cell you want the users to have access, Highlight them right click on the mouse, format cells, last tab is protection uncheck Locked, then protect your sheet if this helps please click yes, thanks "Robernaut" wrote: I work for an accounting firm and we have spreadsheets for everyday usage. We would like to freeze only the cells in which formulas have been entered, so that someone else going into the spreadsheet cannot accidentally delete them. If you can help I would appreciate it. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
How do I freeze formulas when cutting and pasting other cells? | Excel Worksheet Functions | |||
Is there a way to sort without losing individual set formulas? | Excel Worksheet Functions | |||
Calculate and display individual error bars for individual points | Charts and Charting in Excel | |||
How can I freeze formulas in Excel? | Excel Worksheet Functions | |||
Can u lock individual cells (those containing formulas) in an Exc. | Excel Discussion (Misc queries) |