Lawrence

Did you click on the FormatCellsProtection tab to get a list of options?


Gord Dibben Excel MVP

On Thu, 15 Dec 2005 19:16:02 -0800, "Lawrence"
wrote:

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