Detect changes to VBA code.

[myredroom]

Excel VBA (2000 and above)
Is there a way of testing (in Workbook_BeforeClose for example) if there have been any changes to the VBA code this session. I know how to detect for changes (ActiveWorkbook.Saved), but I want to be able to know if the code has changed, so I can automate my change log.

Thanks in advance.

[Bob Phillips]

Don't think so. You could protect the code so that they can't change it, unless they hack it.

[myredroom]

The code is well and truly protected - I just want to automate tracking my own changes to the code.

I'll come up with another solution instead.

[myredroom]

Anyone else with any ideas?

[Bob Phillips]

The code is well and truly protected - I just want to automate tracking my own changes to the code.

I'll come up with another solution instead.

Then use a code management solution.

[myredroom]

Then use a code management solution.

Such as?

[Bob Phillips]

Such as Subversion.