Is it possible to add a version number to a workbook on saving and closing

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
--
ve_2nd_at. Randburg, Gauteng, South Africa


"Tigsboy" wrote:

Is it possible to add a version number to a workbook on saving and closing

Good afternoon Tigsboy

You will need a macro to do this for you, but just to put you on the
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 will
increment the value in cell A1 by 1 everytime the workbook is closed

HTH

DominicB


--
dominicb
------------------------------------------------------------------------
dominicb's Profile: http://www.excelforum.com/member.php...o&userid=18932
View this thread: http://www.excelforum.com/showthread...hreadid=388929