Home |
Search |
Today's Posts |
#5
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
Brilliant!
That works perfectly - thanks very much Ardus. "Ardus Petus" wrote: Paste following code in Workbook's code: Private Sub Workbook_BeforeSave(ByVal SaveAsUI As Boolean, Cancel As Boolean) With Me.Worksheets("Sheet1").Range("A1") .Value = .Value + 1 End With End Sub HTH -- AP "Lozza77" a écrit dans le message de news: ... Is there anyway to automatically increment a number in a spreadsheet everytime the document is saved? ie version number? |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
vlookup with more than number to be retrieved | Excel Worksheet Functions | |||
Preceding a number by zeros, that is still a number | Excel Worksheet Functions | |||
Number of labels on X-axis one more than number of values on Y-axi | Charts and Charting in Excel | |||
Need number of Saturdays and number of Sundays between 2 dates | Excel Worksheet Functions | |||
How do I automatically increment worksheet number when pasting a . | Excel Worksheet Functions |