Improve company productivity with a Business Account.Sign Up

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 495
  • Last Modified:

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
0
Bill Warren
Asked:
Bill Warren
1 Solution
 
Bill WarrenIT ManagerAuthor Commented:
oh by the way were using Excel 2010
0
 
ltlbearand3Commented:
Can you post the workbook minus any confidential information? That would help in looking what what might be happening.

-Bear
0
 
[ fanpages ]IT Services ConsultantCommented:
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.
0
 
Rory ArchibaldCommented:
While we wait, if it is tracking changes to one sheet only, the code is most likely in the module for that sheet. If it is tracking all changes then the code may well be in the ThisWorkbook module.
0
 
Bill WarrenIT ManagerAuthor Commented:
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!
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Free Tool: Port Scanner

Check which ports are open to the outside world. Helps make sure that your firewall rules are working as intended.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now