Is it possible to add a version number to a workbook on saving and closing
K Kassie Jul 21, 2005 #2 Hi Tigsboy Yes it is possible. You can manually change the name of the document, e.g. from Draftv1.xls to Draftv1.1.xls. Or else, you can use a macro to increment your version number every time you save it
Hi Tigsboy Yes it is possible. You can manually change the name of the document, e.g. from Draftv1.xls to Draftv1.1.xls. Or else, you can use a macro to increment your version number every time you save it
D dominicb Jul 21, 2005 #3 Good afternoon Tigsboy You will need a macro to do this for you, but just to put you on th right track: Private Sub Workbook_BeforeClose(Cancel As Boolean) With Range("A1") .Value = .Value + 1 End With End Sub This routine when placed in the ThisWorkbook portion of the VBE wil increment the value in cell A1 by 1 everytime the workbook is closed HTH Dominic
Good afternoon Tigsboy You will need a macro to do this for you, but just to put you on th right track: Private Sub Workbook_BeforeClose(Cancel As Boolean) With Range("A1") .Value = .Value + 1 End With End Sub This routine when placed in the ThisWorkbook portion of the VBE wil increment the value in cell A1 by 1 everytime the workbook is closed HTH Dominic
