Solved: Excel 2007 -> Track Changes

computerman29642 · 17-Nov-2009, 01:36 PM #1

Is there a way to track changes without sharing the workbook?

OBP · 17-Nov-2009, 01:51 PM #2

Chris, I saw a tracking system on here a few Years ago, I can't remember whether I had any Input in to it or not.
Basically you store the Track for each Cell in it's own "Comment" entry. The one that was used was to replace it each time a change was made, so you could see the previous entry, but I don't see why you couldn't just keep adding to it until you reach the limit of the Comment.

computerman29642 · 17-Nov-2009, 01:54 PM #3

Thanks OBP.

OBP · 17-Nov-2009, 02:05 PM #4

Here it is on VBAX not here
http://www.vbaexpress.com/forum/showthread.php?t=8746
and Johnske's version
http://www.vbaexpress.com/kb/getarticle.php?kb_id=783
See also
http://www.vbaexpress.com/forum/showthread.php?t=4366

computerman29642 · 17-Nov-2009, 02:23 PM #5

Thanks, OBP.

I will take a look at the links you provided.

Tag Cloud
access acer asus batch bios bsod computer crash desktop driver drivers error ethernet excel freeze gaming hard drive hardware hdmi internet laptop malware memory modem monitor motherboard mouse network printer problem ram registry router slow software sound trojan ubuntu 11.10 uninstall usb video virus vista wifi windows windows 7 windows 7 32 bit windows 7 64 bit windows xp wireless

Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)

Search
Search for:

Find the solution to yourcomputer problem!

Find the solution to your
computer problem!