track changes

I am using the below code to track changes in the "V&O Register" tab of a workbook I'm using. I would like the 8th value that it spits out (highlighted in red below) to be the value in column B of the same row that the initial change is being made in. The changes are being tracked in a separate...

Hello VB experts I could really use some help on recording changes to a a form control such as a check box. I have the check boxes associated to cell ( one for each control different control) I have this code to record changes to a "log" sheet. It is working fine but when I check a check box or...

Hi, I was tasked to create a daily tracking sheet to see what cell values change each day from input users. So there would be a summary page showing (date, field name, old value, new value). Ideally, I want to data drop the file each day pulled from access and setup some conditional...

Hello all- I have an Excel file I share with lots of people, and I have many formula and numbers scattered through (it basically is a sheet to place orders for goods) What I am wondering is if there is a way when a salesperson goes in and changes a cell, that the cell changes color (or changes...

Hello, I am using VBA to track changes in my worksheet in order to by-pass all of the known issues with Shared Workbooks and get similar functionality. I have pieced together code from various places to get a pretty good solution, but I am having problems tracking changes to checkbox values! My...

I know how to track changes and view the history but can I track changes to checkboxes and option boxes?

Hi everyone, Recently I have started recording and editing macros. I am really new in this field and I am not able to find the solution for one of the latest macros I have recorded. When I run the macro below I get the following error message: Run-Time error '1004': Method...

Hi, This is my first post- please forgive/inform me of any mistakes. I am trying to automate a repetitive reporting process. Before I can upload my reports, I have to protect a sheet, protect the workbook, and "Protect Shared Workbook." This last step brings up a box where I check "Sharing...

Hi all, New to the forum. I have a quick question hopefully someone can help me with. So I found this neat VBA code online to extract the comments from a comment into a cell by using =getcomment() formula. here is the code I used: Function GetComments(rngTemp As Range) If Not...

Hi, I have a project where when the user enters the excel file a userform is displayed to them where they enter their username and passowrd, for lotus notes, in order to continue. They then go to another userform where they enter information then click ok and are taken to a spreadsheet where...

Greetings, I am trying to have one cell (G5) populate with a timestamp when a change is made to any cells in a range (some are merged). The code below worked for a second, until it didn't. Any help would be greatly appreciated. Private Sub Worksheet_Change(ByVal Target As Range) If...

Hi, Request you to help me out with the following. I have a workbook by the name 1Hiten.xls, the problem is that its a very heavy workbook and keeping a track of changes made on it is very difficult. I dont want to use the track options in the 1Hiten.xls, or use any vba on this workbook...

I have created a "track changes" script that more closely resembles the way is performed in MS Word. It accomplishes this by walking through each word of an edited text and compares it to the words in a base text. The result of the comparison is then placed into a result cell using the...

Hello all, What I am trying to do is track changes between two workbooks / worksheets. (I dont mean to track user changes, this is not to see what someone has changed in my table.) I use a software called Crystal that pulls info from payroll and put it into an Excel table. Use Crystal to make...

I tried to use the standard function track changes. But this is greyed out when i have a linked workbook. Is there anyway to track changes when i refresh data in excel to write an history record with old and new value from certain columns!

Hello, can someone please give me the code to disable deleting/editing comments in a worksheet (excel 2007). I am trying to build a code that track users actions using comments, where a comment is automatically added when a user makes changes, but what i need now is to disable deleting and...

Hello! I currently have an Excel file (using Excel 2007 and sharing turned on) with track changes enabled. All of the numeric values in the worksheet are set to 4 decimal places. However, when we make a change to one of the values, the track change "hover-over" note, as well as the change...

I am trying to track changes in a complex workbook with pivot tables and macros. This worked fine on a basic trail, but when used on the complex spreadsheet and we tried to print , we got a run time error 1004 - you cannot create or make changes to PIVOTTABLE reports in a shared workbook. Does...

Hi, i am looking for code that can take the tracked changes on a word doc and place in a new file in a different folder. I need to do this for multiple documents all located in the same folder. Then i need to compare the new docs generated to see if there a difference in the tracked changes i.e...

I've been working on a shared file where I occasionally need to turn off sharing, but I don't want to lose the history log (produced by "Track Changes." I thought I had a "SaveHistoryLog" macro working fine, but then it seems to work sometimes and other times give different run-time errors...