Track changes within a workbook without sharing the workbook

[mhitch2017]

Looking to track changes on a separate tab in a workbook without placing the workbook as a "Shared Workbook". I have heard the best way would be to use a VBA Event Handler. I am not good with code, I could understand it by reverse engineering it if I had some idea of what the code meant in relation to the tabs.
Thanks

[Logit]

.
Paste this code in the ThisWorkbook module :

Please Login or Register  to view this content.

You can hide the TRACKER sheet, which is password protected, so only you have access.

[enhydra]

Hi Logit, Do you know a way to add computer name or host name?

Thanks,

Madison

[Logit]

.
I added the 'Environ' command here :

Please Login or Register  to view this content.

[enhydra]

Thanks Logit. I changed it to "ComputerName". This is the best tracking code I have ever seen.

[Logit]

.
You are welcome.

I agree ... it's a pretty nifty project. Can't claim credit for most of it though ... got most of it from somewhere.

Cheers.

ps: Be certain to change the wording in the Macro as well for "ComputerName"

Please Login or Register  to view this content.

[mhitch2017]

Hi Logit,
Thanks for your help. I did not see your response until today when I came back to work. I will attempt this but do you have the password to the protected sheet. I attempted to view the code on this sheet and cannot see it. Is that because it is protected?

Thanks again.

[Logit]

.
The code is on the ThisWorkbook module. Once you get into the VBE, doubleclick on ThisWorkbook. The project does not have a password.

[mhitch2017]

Logit,
I wanted to say thank you for your help on this. It is working great, there are few things that it will not track but at this time it is working and I am happy with the results. It auto saves after every entry and will not let you undo it.

Thank you for your time.

[Logit]

.
What is it not tracking ? I haven't noticed that here. Curious.

[mhitch2017]

Does not track when you autofill down.(Number Sequence)
Does not track when you insert or delete rows or columns.
Does not track merged cells old value.
Does not track copy & paste to multiple cells, only one at a time.
Sometimes you may have double click the cell then press enter for it to acknowledge the change.
Hope this helps.

[elayaz]

Hello @logit, I was trying to use your file - Track Changes Log - xlsx sheet.xlsm‎ and I want to delete the data from the Track changes sheet.. But while trying to delete its asking for a password. Is it password protected?

[Logit]

.
No passwords. I don't understand why that is happening for others.

Here is the file again. Hopefully it won't cause any issues :

[elayaz]

Hi

Thanks for uploading.

Please Login or Register  to view this content.

found the password

Thanks for the code, so helpful to begin with solving my problem.

[CastorSunshine]

Hi
Thanks for sharing this! It was perfect for what I'm working on.

Is there a way to have it not track changes for certain sheets?

[anjalr93]

Hi,
Great code! But if I want it to show the old value on merged cells, how do I do this?

[FDibbins]

Hi,
Great code! But if I want it to show the old value on merged cells, how do I do this?

Administrative Note:

Welcome to the forum.

We are happy to help, however whilst you feel your request is similar to this thread, experience has shown that things soon get confusing when answers refer to particular cells/ranges/sheets which are unique to your post and not relevant to the original. Please start a new thread - See Forum rule #4

If you are not familiar with how to start a new thread see the FAQ: How to start a new thread