Thread: Formulas
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
John C[_2_] John C[_2_] is offline
external usenet poster
 
Posts: 1,358
Default Formulas

The easiest way is through sheet protection. You first have to unlock all the
cells the users will need access to (select the cells, go to format--cells,
o to the protection tab, and uncheck the Locked box. Then, for all the cells
that you want to 'hide' the formulas, select those and check the hidden box.
Then protect the sheet, with password (otherwise the user could just
unprotect).
--
John C


"Dinesh" wrote:

Hi,

Can anyone suggest me how to hide formulas on a worksheet that is used by
several users to update.