Spreadsheet identification.

G

greg7468

Hello all, I compile spreadsheets that maybe updated daily, I then sen
these files out (anything up to monthly).
I am looking for a way of easily identifying which version they ar
looking at if they have any queries.
I would like to keep the file name the same and did not want to have t
change anything manually.
I was thinking ideally of say a number in cell A1 that increases by
every time I save the file. I would then compare this to their numbe
to know whether the file they are looking at is the most up to dat
version.
If anyone has any other ideas they would be most welcome.
p.s I am failrly inexperienced in Excel.
Thanks in advance for all help
 
F

Frank Kabel

Hi
put the following code in your workbook module (not in a standard
module):

Private Sub Workbook_BeforeSave(ByVal SaveAsUI As Boolean, Cancel As
Boolean)
with me.worksheets("sheet1").range("A1")
.value = .value+1
end with
End Sub
 
Top