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

Unprotect sheet.

go to the cell(s) that have forumlas that you don't want the users to see.
Go to menu: Format|Cells, go to protection tab, check the Hidden box. Then
protect the sheet with password. The formulas will calculate, but the actual
formula will not be visible.
--
John C


"Jase" wrote:

Is their a way to hide formulas under a password protection with in excel
sheets so the user can not see the formulas? I know how to hide formulas but
I want to only be able to access the formulas through password protection.

Jase