The green tickmarks do not necessarily indicate formulas. They indicate what
Excel thinks is an error or anomaly in the cell.

Try ToolsOptionsError Checking. Uncheck the option and the green triangles
will go away.

To hide the formulas in the formula bar you can select the cells and
FormatProtectionHidden.

Then protect the worksheet under ToolsProtectionProtect Sheet.


Gord Dibben Excel MVP

On Mon, 13 Jun 2005 07:17:11 -0700, "Phil Wales"
wrote:

Try:
Tools< Options<View then deselect the fromula bar




"DNA" wrote:

How do you turn the green ticks marks off so you don't know cells contain a
formula. Does everyone know what I'm talking about?