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
|