Results 1 to 5 of 5
  1. #1
    Lounger
    Join Date
    Aug 2005
    Posts
    45
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Tracking changes in excel file (excel 2000/2003)

    Hello,

    I am trying to see if there is a way we can track changes in excel file either via VB or any other way. I was also wondering if anyone knows how I can go about stepping into a macro to watch each line of VB(macro) is doing. I would like to see both the worksheet and the VB in the screen as is stepping into it. Thanks.

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

    Re: Tracking changes in excel file (excel 2000/2003)

    1) See Tools | Track Changes...

    2) You can arrange the Excel and Visual Basic Editor (VBE) windows side by side, or maximize Excel and place the VBE window so that it leaves the relevant part of the worksheet visible.
    Click in a macro, then press F8 to single-step through the code. You can inspect the value of variables, properties etc. by hovering the mouse pointer over them in the code.
    You can resume automatic execution by pressing F5.
    You can also set a breakpoint on a line by clicking in the grey margin to the left of it, or by clicking in the line and pressing F9. (Repeating this toggles the breakpoint off)
    When you run the macro, execution pauses at the breakpoint, you can then use F8 to single-step.

  3. #3
    Lounger
    Join Date
    Aug 2005
    Posts
    45
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Tracking changes in excel file (excel 2000/2003)

    Thanks Hans. Do you know if there is a way to get a history for an excel file of a user making changes. For example, I want find out the last person that made changes to a file and date.

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

    Re: Tracking changes in excel file (excel 2000/2003)

    Again: See Tools | Track Changes...

    There is an option to display a history of changes in a separate worksheet. This option will only become available after the workbook has been saved as a shared workbook.

    By the way, sharing workbooks is a possible source of workbook corruption. Unless you absolutely need this, I would recommend NOT sharing a workbook (and hence, not being able to track changes)

  5. #5
    3 Star Lounger
    Join Date
    Dec 2000
    Location
    Vancouver, Br. Columbia, Canada
    Posts
    268
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: Tracking changes in excel file (excel 2000/2003)

    <hr>"By the way, sharing workbooks is a possible source of workbook corruption."<hr>
    It also leads to unbelievable file bloat and slows excel down like nothing you have ever seen before (at least on our system) - tried it once; won't make that mistake again....

Posting Permissions

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