Results 1 to 2 of 2
  1. #1
    New Lounger
    Join Date
    Mar 2008
    Location
    South Dakota
    Posts
    1
    Thanks
    0
    Thanked 0 Times in 0 Posts

    precedents (exel 2000)

    when I use the precedents in my worksheet, and I save the worksheet the precedents disappear. any suggestions on how to keep them from disappearing?

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: precedents (exel 2000)

    Welcome to Woody's Lounge!

    The results of Trace Precedents and Trace Dependents is never stored with the workbook, so I'm afraid you'll have to set it up again each time. You could create a macro:

    Sub ShowPrecedentsSelection()
    Dim oCell As Range
    For Each oCell In Selection.Cells
    oCell.ShowPrecedents
    Next oCell
    End Sub

    in your Personal.xls macro workbook and assign it to a toolbar button and/or keyboard shortcut so that you can easily show precedents for all selected cells in one go.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •