Track changes on non-shared workbook
I have a user that created a workbook which I believe placed track changes vb code somewhere into the file. As it is tracking changes to a sheet and is not a shared file. However I have looked into the VBA code as well as the macros and cannot find it. the user cannot remember how she did it and I'm to find out what happened. Does anyone have an idea where the code could be?
By the way when you go into the review tab and select track changes the track changes selection box is not checked. Any help is appreciated
By the way when you go into the review tab and select track changes the track changes selection box is not checked. Any help is appreciated
Can you post the workbook minus any confidential information? That would help in looking what what might be happening.
-Bear
-Bear
![Avatar of [ fanpages ]](https://filedb.experts-exchange.com/files/public/2020/2/28/4acbe344-900b-4e79-96ce-65fe58a6f004.png){kind=small}
Hi,
Perhaps the code was placed within a Personal Macro workbook instead of the main workbook you are using.
For reference, "Copy your macros to a Personal Macro Workbook":
[ http://office.microsoft.com/en-gb/excel-help/copy-your-macros-to-a-personal-macro-workbook-HA102174076.aspx ]
However, as Bear suggested, being able to see the workbook would help.
Thanks.
BFN,
fp.
Perhaps the code was placed within a Personal Macro workbook instead of the main workbook you are using.
For reference, "Copy your macros to a Personal Macro Workbook":
[ http://office.microsoft.com/en-gb/excel-help/copy-your-macros-to-a-personal-macro-workbook-HA102174076.aspx ]
However, as Bear suggested, being able to see the workbook would help.
Thanks.
BFN,
fp.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Thanks to all of the suggestions! After further inspection I did find the code in the ThisWorkbook code sheet... and was able to resolve the problem thanks a bunch for the help!
ASKER