Track Changes without sharing a workbook?

A

Andrew

Is there any macro that could track changes in an Excel workbook without the
workbook being shared? I came across the following macro:

Dim nFile
nFile = FreeFile
Open "C:\MyLog.txt" For Append As #nFile
Print #nFile, "Workbook " & ThisWorkbook.Path & _
" opened by " & Environ("UserName") & _
" on " & Format(Now, "yyyy/mm/dd hh:mm:ss")
Close #nFile

which saves a list of when the file is accessed. But I've no idea how to
amend this to list any changes to the the workbook. In actual fact, it's
only one specific sheet that I need to track, however the nature of the file
won't allow me to share it.

Any help would be much appreciated.

Andrew.
 
J

JMay

Bob, Thanks for the modified code. I have incorporated it into my code and
the formatting is doing fine particularly if a pass-thru target cell is all
positives (=100+200.12+300.13) - Displaying in the Userform1 as:

100.00
200.12
300.13

But if any of the Pass-thru target cells have a Negative value - there is a
problem..
say like (=11.69+66.47+891.55-50) - It is displaying in the Userform1 as:

11.69
66.47
+891.55-50

any idea how this can be remedied?
I plan on working on over the weekend, but if you have any thought, let me
know.

Tks,
Jim
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top