+ Reply to Thread
Results 1 to 5 of 5

Track changes within a workbook without sharing the workbook

  1. #1
    Registered User
    Join Date
    11-08-2017
    Location
    Springfield, MO
    MS-Off Ver
    2013
    Posts
    7

    Track changes within a workbook without sharing the workbook

    Need to track changes in a workbook on a separate tab. Any help on this would be greatly appreciated?

    Thanks in advance.

  2. #2
    Valued Forum Contributor than_gold's Avatar
    Join Date
    10-17-2017
    Location
    Coimbatore India
    MS-Off Ver
    Office 365
    Posts
    646

    Re: Track changes within a workbook without sharing the workbook

    Hello,
    Please refer below page.

    https://www.gcflearnfree.org/excel20...nd-comments/1/

    Thangavel D
    Regards,
    Thangavel D

    Appreciate the help? CLICK *

  3. #3
    Forum Guru TMS's Avatar
    Join Date
    07-15-2010
    Location
    The Great City of Manchester, NW England ;-)
    MS-Off Ver
    MSO 2007,2010,365
    Posts
    44,090

    Re: Track changes within a workbook without sharing the workbook

    You'd need to use a VBA Change Event handler ... and force users to enable macros.
    Trevor Shuttleworth - Retired Excel/VBA Consultant

    I dream of a better world where chickens can cross the road without having their motives questioned

    'Being unapologetic means never having to say you're sorry' John Cooper Clarke


  4. #4
    Forum Guru TMS's Avatar
    Join Date
    07-15-2010
    Location
    The Great City of Manchester, NW England ;-)
    MS-Off Ver
    MSO 2007,2010,365
    Posts
    44,090

    Re: Track changes within a workbook without sharing the workbook

    The OP said he didn't want to share the workbook. Track Changes automatically shares the workbook.

  5. #5
    Registered User
    Join Date
    11-08-2017
    Location
    Springfield, MO
    MS-Off Ver
    2013
    Posts
    7

    Re: Track changes within a workbook without sharing the workbook

    Can you do this in Excel 2013? How?

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Track Changes without sharing the workbook
    By Cameronl in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 11-11-2017, 02:55 AM
  2. Replies: 4
    Last Post: 09-05-2015, 08:41 PM
  3. Sharing a Workbook with with connections to another workbook
    By mmanning in forum Excel Charting & Pivots
    Replies: 2
    Last Post: 06-22-2015, 04:53 PM
  4. Track changes without sharing workbook
    By naomi in forum Excel - New Users/Basics
    Replies: 1
    Last Post: 02-04-2008, 04:29 PM
  5. Replies: 1
    Last Post: 12-16-2006, 04:23 PM
  6. Sharing a Workbook
    By jennie in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 09-15-2006, 06:32 AM
  7. sharing a workbook
    By mprible in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 09-06-2005, 10:05 AM

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