myredroom
08-06-2010, 02:24 AM
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.
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.