Green Tick Marks

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?

From Microsoft's website:

"For more information about error types and how to correct them, click
Microsoft Excel Help on the Help menu, type 'find and correct errors in
formulas' in the Search for box in the Assistance pane, and then click Start
searching to view the topic."

HTH
Jason
Atlanta, GA

"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?
>
>

There's nothing wrong with the formulas. The spreadsheet is fine on my PC,
when I emailed it, the other user has the green tick marks. They have not
changed the formulas.

You need to protect the sheet and then they will go away.
These ****ing things are a curse. No one I know wants them, they are just MS
giving help where help is not wanted.
Go on Tools > Options and also 'Auto Correct' options and look for 'Smart
Tags'.
Disable the annoying SOB's and you should be OK
Regards,
Alan.
"DNA" <[email protected]> wrote in message
news:[email protected]...
> There's nothing wrong with the formulas. The spreadsheet is fine on my
> PC,
> when I emailed it, the other user has the green tick marks. They have not
> changed the formulas.
>

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?
>
>

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

Try Tools>Options>Error 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
Format>Protection>Hidden.

Then protect the worksheet under Tools>Protection>Protect Sheet.


Gord Dibben Excel MVP

On Mon, 13 Jun 2005 07:17:11 -0700, "Phil Wales"
<[email protected]> 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?
>>
>>