Hi:

Is there a help file (or some documentation) for Excel 4.0 macros available
for Excel 2003? I know that such a file exists for Excel 2000, but Excel
2003 help has this to say about that file "Important You can only use this
help file with Microsoft Excel 2000." I am looking specifically for
documentation on the TRACER.DISPLAY method.

Thank you in advance.

I have a Help file for Excel 4 macros. I got it from the Internet, but forgot where from, possibly a MS site. Maybe you can google
it.

My file tells me this about Tracer.display:
================================
Macro Sheets Only
Equivalent to clicking the Trace Precedents or Trace Dependents buttons on the Auditing toolbar on a worksheet. Allows tracer
arrow to be graphically displayed showing relationship among cells.

Syntax

TRACER.DISPLAY(direction, create)
Direction is logical value which, if TRUE, displays tracer arrows for precedents. If FALSE tracer arrows for dependents are
displayed.
Create is a logical value which, if TRUE displays the next level of tracer arrows in the direction specified by direction. If
FALSE, removes the current level of tracer arrows in the direction specified by direction. A level is the number of "arrows" away
from the source cell.

Remark

Returns the #VALUE! error value if not available; for example, the selection is something other than a worksheet, or the cell(s)
cannot be traced.

Related Functions

TRACER.CLEAR Clears all tracer arrows on the worksheet
List of Command-Equivalent Functions
================================


--
Kind regards,

Niek Otten
Microsoft MVP - Excel


"Scott P" wrote in message ...
| Hi:
|
| Is there a help file (or some documentation) for Excel 4.0 macros available
| for Excel 2003? I know that such a file exists for Excel 2000, but Excel
| 2003 help has this to say about that file "Important You can only use this
| help file with Microsoft Excel 2000." I am looking specifically for
| documentation on the TRACER.DISPLAY method.
|
| Thank you in advance.

Many thanks, Niek. This is very helpful and appreciated.

"Niek Otten" wrote:

I have a Help file for Excel 4 macros. I got it from the Internet, but forgot where from, possibly a MS site. Maybe you can google
it.

My file tells me this about Tracer.display:
================================
Macro Sheets Only
Equivalent to clicking the Trace Precedents or Trace Dependents buttons on the Auditing toolbar on a worksheet. Allows tracer
arrow to be graphically displayed showing relationship among cells.

Syntax

TRACER.DISPLAY(direction, create)
Direction is logical value which, if TRUE, displays tracer arrows for precedents. If FALSE tracer arrows for dependents are
displayed.
Create is a logical value which, if TRUE displays the next level of tracer arrows in the direction specified by direction. If
FALSE, removes the current level of tracer arrows in the direction specified by direction. A level is the number of "arrows" away
from the source cell.

Remark

Returns the #VALUE! error value if not available; for example, the selection is something other than a worksheet, or the cell(s)
cannot be traced.

Related Functions

TRACER.CLEAR Clears all tracer arrows on the worksheet
List of Command-Equivalent Functions
================================


--
Kind regards,

Niek Otten
Microsoft MVP - Excel


"Scott P" wrote in message ...
| Hi:
|
| Is there a help file (or some documentation) for Excel 4.0 macros available
| for Excel 2003? I know that such a file exists for Excel 2000, but Excel
| 2003 help has this to say about that file "Important You can only use this
| help file with Microsoft Excel 2000." I am looking specifically for
| documentation on the TRACER.DISPLAY method.
|
| Thank you in advance.