Results 1 to 3 of 3
  1. #1
    Silver Lounger
    Join Date
    Jul 2001
    Location
    Ottawa, Ontario, Canada
    Posts
    1,609
    Thanks
    0
    Thanked 1 Time in 1 Post
    I have always found the UI for Formula Auditing to be too mouse intensive. The attached Add-In (Selective_Auditing.xla), is my humble attempt to improve the situation. When attached, it will add the Sel Auditing menu to the Worksheet Menu Toolbar. I believe that this UI is sufficiently intuitive that no instructions are necessary. The code is open. Please try it out and advise me of any faults which you find either in the philosophy, implementation or code. The speed tests which I have run indicate that the time penalty in changing the cell selection is:

    * Less than 0.5 ms with the add-in attached but neither precedents nor dependents selected for display.

    * Less than 2 ms with both precedents and dependents selected for display.

    These delays should not be noticeable when operating manually, but should be considered when determining whether to Enable Events during macro execution.

    Many thanks to Hans and Jan Karel for their guidance.

    [attachment=90930:Selective_Auditing_1_a.zip]
    Attached Files Attached Files
    Regards
    Don

  2. #2
    New Lounger
    Join Date
    Dec 2009
    Location
    Kingsport, TN,USA
    Posts
    5
    Thanks
    0
    Thanked 0 Times in 0 Posts
    Which version/s of Excel will it work with?
    Ben

  3. #3
    Silver Lounger
    Join Date
    Jul 2001
    Location
    Ottawa, Ontario, Canada
    Posts
    1,609
    Thanks
    0
    Thanked 1 Time in 1 Post
    Quote Originally Posted by Ben Nottingham View Post
    Which version/s of Excel will it work with?
    Ben
    It was composed in 2003, I believe that Hans has run it in 2007. It should work in all versions.
    Regards
    Don

Posting Permissions

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