+ Reply to Thread
Results 1 to 14 of 14

Tracking Log

  1. #1
    Registered User
    Join Date
    01-11-2018
    Location
    Miami, FL
    MS-Off Ver
    2013
    Posts
    13

    Tracking Log

    Hello all,

    I was wondering if someone out there would be able to help me with adding a tracking log to a workbook I am working on. I have a file that has a somewhat exact example of the tracking log (attachment - 8097 (1)), but since I am not very familiar with VBA, I can't figure out how to add this code to my file (attachment - Staffing Levels). Thank you in advance for anyone that can help me with this.
    Attached Files Attached Files

  2. #2
    Registered User
    Join Date
    01-11-2018
    Location
    Miami, FL
    MS-Off Ver
    2013
    Posts
    13

    Re: Tracking Log

    Please help anyone?

  3. #3
    Forum Contributor
    Join Date
    07-10-2019
    Location
    england
    MS-Off Ver
    2013
    Posts
    236

    Re: Tracking Log

    Kindly explain me, what you want to do?

  4. #4
    Forum Expert Logit's Avatar
    Join Date
    12-23-2012
    Location
    North Carolina
    MS-Off Ver
    2007 Enterprise
    Posts
    4,844

    Re: Tracking Log

    .
    I've added a Tracker to your workbook . See code below and attached. (The tracker code you posted was convoluted and difficult to implement.)

    Please Login or Register  to view this content.
    Attached Files Attached Files

  5. #5
    Registered User
    Join Date
    01-11-2018
    Location
    Miami, FL
    MS-Off Ver
    2013
    Posts
    13

    Re: Tracking Log

    Thank you so much this works very well. I was viewing the code in the other document I uploaded and it really was complicated.

    Quick question, is it possible to have the changed cells highlight and in the Tracker sheet with a button to approve edits?

    Thanks again.

  6. #6
    Forum Expert Logit's Avatar
    Join Date
    12-23-2012
    Location
    North Carolina
    MS-Off Ver
    2007 Enterprise
    Posts
    4,844

    Re: Tracking Log

    .
    Highlight the changed cells is doable.

    Explain what you mean by approving the edits. Have another cell on each line of change indicating the change was approved by someone ... or what ?

  7. #7
    Registered User
    Join Date
    01-11-2018
    Location
    Miami, FL
    MS-Off Ver
    2013
    Posts
    13

    Re: Tracking Log

    So if the user opens the file and makes any changes, those changed cells will highlight until another user (approver) opens the file and accesses the "tracker" sheet. The approver will review all edits then select a button (approve edits) which clears the highlighted cells while continuing to still record all changes including the approver selecting the "approved edits" button.

  8. #8
    Forum Expert Logit's Avatar
    Join Date
    12-23-2012
    Location
    North Carolina
    MS-Off Ver
    2007 Enterprise
    Posts
    4,844

    Re: Tracking Log

    .
    Added to a regular module :

    Please Login or Register  to view this content.
    Attached Files Attached Files

  9. #9
    Registered User
    Join Date
    01-11-2018
    Location
    Miami, FL
    MS-Off Ver
    2013
    Posts
    13

    Re: Tracking Log

    Fantastic! Thank you so much.

  10. #10
    Forum Expert Logit's Avatar
    Join Date
    12-23-2012
    Location
    North Carolina
    MS-Off Ver
    2007 Enterprise
    Posts
    4,844

    Re: Tracking Log

    You are welcome.

  11. #11
    Registered User
    Join Date
    01-11-2018
    Location
    Miami, FL
    MS-Off Ver
    2013
    Posts
    13

    Re: Tracking Log

    So I came across something else. I would like to hide or very hidden this sheet, if not those I would like to password protect the sheet so that nobody can make changes to the tracked edits. Is this possible?

  12. #12
    Forum Expert Logit's Avatar
    Join Date
    12-23-2012
    Location
    North Carolina
    MS-Off Ver
    2007 Enterprise
    Posts
    4,844

    Re: Tracking Log

    .
    Paste the new macro in the ThisWorkbook module :

    Please Login or Register  to view this content.

  13. #13
    Registered User
    Join Date
    01-11-2018
    Location
    Miami, FL
    MS-Off Ver
    2013
    Posts
    13

    Re: Tracking Log

    Thank you for all of your help. You have been very helpful and patient as I keep coming back with questions. the last module you gave me worked well, but I think I may have one more question. I replied to this post here because as I am finalizing the excel file and started adding color to my title headers whenever I press the approve button it clears my header's colors as well. Is there any way to prevent this?

  14. #14
    Registered User
    Join Date
    01-11-2018
    Location
    Miami, FL
    MS-Off Ver
    2013
    Posts
    13

    Re: Tracking Log

    Quote Originally Posted by Logit View Post
    .
    Added to a regular module :

    Please Login or Register  to view this content.
    Thank you for all of your help. You have been very helpful and patient as I keep coming back with questions. the last module you gave me worked well, but I think I may have one more question. I replied to this post here because as I am finalizing the excel file and started adding color to my title headers whenever I press the approve button it clears my header's colors as well. Is there any way to prevent this?

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

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