Saving Trace precedent trace dependent arrows

[John]

In the formula auditing tool bar we can trace precents and
dependents for calculations. However, when I save the
spreadsheet the arrows showing these disappear. How can I
save the arrows so that I or another user can see them
later?

 

[Bob Phillips]

John,

You could use this simple worksheet open event code

Private Sub Workbook_Open()
Dim cell As Range

DisplayAlerts = False
For Each cell In ActiveSheet.UsedRange
If cell.HasFormula Then
cell.ShowPrecedents
cell.ShowDependents
End If
Next cell
End Sub

But be warned, it shows all precedents and dependents, and on the sheet I
tested it on, all I could see was a mass of blue lines.