Vba Version Tracker

[dannyok90]

Hi All,

I'm in need of some Vba help (As usual)

Id like to implement a version tracker into my spreadsheet.


Basically,


I have a workbook with multiple sheets,


when I update any cell on the "communication plan" sheet
id like a box to pop up that says something like "Changes will create a new version"
update the version number in cell P2
save the spreadsheet to a file path on sheet 1 cell a1
with the name in cell c1 on "communication plan" sheet.


The code needs to understand that any changes after that are part of the new version.. essentially the code would reset once the workbook is closed and opened again.

Any help would be greatly appreciated :D

 

[James006]

Hello,

You could test following:

Sub TestVBAVer()
  MsgBox Application.VBE.Version
End Sub

Hope this will help