View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.misc
 
Posts: n/a
Default Locking down propriety spreadsheets

Another trick to foil finding the Conditional formatting (after doing
it differently in several areas of the worksheet, an example
=istext($B$1)., then condition to "white fontt". and copy to whatever
you want blanked out. In another cell put = isblank($AA$16) formatted
"white font" and copy it to SOME OF the same cells.

Remember, all of this is for your phony data to give the hacker's the
run around. Preserve a clear path for your people to read and
construct without unravelling all the garbage you inventeted for
hackers. ed