Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
macro runs when workbook is saved, but only with vba change...
Hi All,
I'm looking to implement some pretty simple version controlling processes on our model (which is basically a collection of excel spreadsheets with lots of custom vba underneath)... Obviously part of this would involve having version stamps in the title of any given file, eg data_cruncher_v_1.xls might become data_cruncher_v_1.1.xls after a change is made to the vba in it. I'd like this incrementation of version stamps to be as easy as possible, and not require the developers to have to do it by hand. I'd also like the version stamps to increase *only* if the vba is changed and saved - not if there are any changes to data held on spreadsheets within the xls workbook. My question is this: is it possible to have a macro run (which would do all the renaming etc) when the workbook is saved (trivial) but more specifically, only when there has been a change to any of the vba within a workbook and it is saved. Any help would be appreciated - I've had a look through this group for similar and not been able to find anything, but sincere apologies if this question has already been asked previously. Many thanks Chris |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Before macro runs - check workbook name | Excel Programming | |||
Macro runs in source , but not when in Personal Macro Workbook | Excel Programming | |||
Links in formulas change when another user runs a workbook - 2003 | Excel Programming | |||
Links in formulas change when another user runs a workbook | Excel Discussion (Misc queries) | |||
Excel Workbook automatically (by design) runs a macro | Excel Programming |