Hi Rowan,
Yeah, you are correct. The cell still has to be hidden, through
FormatProtectionHidden.
Sorry for any confusion.
Dave
Rowan Drummond Wrote:
That would hide the result but the formula would still be visible in
the
formula bar.

Regards
Rowan

Desert Piranha wrote:
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...

LawrenceHi Lawrence,

Another way is custom format the cells with ;;; that is three
semicolons.
FormatCellsCustom key in ;;; click Ok
Then protect the sheet.




--
Desert Piranha


------------------------------------------------------------------------
Desert Piranha's Profile: http://www.excelforum.com/member.php...o&userid=28934
View this thread: http://www.excelforum.com/showthread...hreadid=494038