Saving Trace precedent trace dependent arrows

  • Thread starter Thread starter John
  • Start date Start date
J

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?
 
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.
 
Back
Top