View Single Post
  #6   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Desert Piranha
 
Posts: n/a
Default how to cover the formula


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