• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 197
  • Last Modified:

track changes to code in excel

Is there any way to track code changes in excel?  I got the following error when trying to find that in the help files >> http://screencast.com/t/P9OGoKUJOu2g
1 Solution
Chris BottomleySoftware Quality Lead EngineerCommented:
track code changes - as in log edits to the VBA in the editor.  Nope, although theoretically you could compare the original against a reference ... as long as the reference was protected from change.

This would however be a static check rather than a record of edits as/when they occur.  Essentially though the answer is no.

If you're looking for changes to the spreadsheet (rather than code) then you'll want to look at the Review tab (in 2007/2010) and select Track Changes / Highlight Changes.  In 2003, I think it's under the Data menu.
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

Cloud Class® Course: CompTIA Cloud+

The CompTIA Cloud+ Basic training course will teach you about cloud concepts and models, data storage, networking, and network infrastructure.

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