+ Reply to Thread
Results 1 to 3 of 3

Shared Workbook - Can you access tracked changes data via VBA?

  1. #1
    Registered User
    Join Date
    04-02-2012
    Location
    London, England
    MS-Off Ver
    Excel 2003
    Posts
    2

    Shared Workbook - Can you access tracked changes data via VBA?

    Hi,
    I have a shared workbook that is tracking changes made to it. I would like to use VBA to report on who was the last person to change each cell.
    So for example if cell A1 has changed, I would like to be able to find out programatically who changed it and when.
    Where does Excel store the data it keeps related to tracked changes?
    Thanks.

  2. #2
    Valued Forum Contributor
    Join Date
    03-14-2012
    Location
    Arizona USA
    MS-Off Ver
    Excel 2000/2007
    Posts
    408

    Re: Shared Workbook - Can you access tracked changes data via VBA?

    On a project that I did some time ago, I created a shared workbook that had a login macro. Each user had a worksheet devoted to them. The login macro would verify who they are, would hide all other worksheets but theirs and would save the current user's name. The current user's name would get appended to log entries anytime a change was made to the workbook.

  3. #3
    Registered User
    Join Date
    04-02-2012
    Location
    London, England
    MS-Off Ver
    Excel 2003
    Posts
    2

    Re: Shared Workbook - Can you access tracked changes data via VBA?

    Thanks for your reply.
    The shared workbook will not be containing any macros itself. I do not want to implement my own custom track changes code. I purely want to access the changes data that Excel is recording.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Tags for this Thread

Bookmarks

Posting Permissions

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1