+ Reply to Thread
Results 1 to 5 of 5

Track changes within a workbook without sharing the workbook

Hybrid View

  1. 11-10-2017, 12:20 PM #1
    mhitch2017
    mhitch2017 is offline
    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.
    Reply With QuoteRegister To Reply
  2. 11-10-2017, 12:51 PM #2
    than_gold
    than_gold is offline
    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 *
    Reply With QuoteRegister To Reply
  3. 11-10-2017, 12:52 PM #3
    TMS
    TMS is online now
    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
    48,330

    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

    Reply With QuoteRegister To Reply
  4. 11-10-2017, 02:08 PM #4
    mhitch2017
    mhitch2017 is offline
    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 With QuoteRegister To Reply
  5. 11-10-2017, 12:57 PM #5
    TMS
    TMS is online now
    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
    48,330

    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.
    Reply With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next 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. Sharing a workbook with formulas linked to another workbook
    By gers in forum Excel General
    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. track who enters into the workbook and what time and when they leave the workbook
    By khalid79m in forum Excel General
    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. [SOLVED] 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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1