how to cover the formula
Hi!
Try this:
Hit CTRL A
Goto FormatCellsProtection tab
Uncheck Locked
OK
Now, select the cells with the formulas that you want protected.
Goto FormatCellsProtection tab
Check Locked
Check Hidden
OK
Now, protect the sheet
Goto ToolsProtectionProtect sheet.
Depending on which version of Excel you are using, there are various options
for protection. Choose the ones you want .
Biff
"Lawrence" wrote in message
...
Ron,
i couldn't find the Locked and hidden... i just able to see the Protection
only...
"Ron Coderre" wrote:
Have you tried :
FormatCellsProtection
Checked: Locked and Hidden
When you protect the sheet, users won't be able to see the formula or
change
it.
Does that help?
***********
Regards,
Ron
"Lawrence" wrote:
hi,
could anyone tell me how to cover the formula in the column, so that
people
unable see what the formula i have put in.
thanks in advance...
Lawrence
|