View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Eduardo Eduardo is offline
external usenet poster
 
Posts: 2,276
Default How do I freeze individual cells with formulas in them

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.