Hi Bony,

yet when I enter selection.showdependents it shows the dependency "button"
and arrow.

If I look at selection in the watch window,
Dependents - (No cells were found)
Directdependents - (No cells were found)

Please can anybody shed some light on this?

The Dependents collection only shows dependents on the same worksheet. The
ShowDependents method shows the arrows pointing to other worksheets too.

Regards,

Jan Karel Pieterse
Excel MVP
http://www.jkp-ads.com