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