Hello,
I have an excel workbook with a number of users (a lot that I don't know who they are and the people might change). In order so they are kept up to date of what changes have happened to the workbook though, I would like to input a 'changelog' that automatically opens when they open the excel file. However, I am not planning on making many changes in the future, and so I would like the userform to only appear for say 40 days, and then disappear.
Is this possible?
The icing on the cake would be a count down in days until the message disappears...!
The basic code I've got to open the userform is:
I have an excel workbook with a number of users (a lot that I don't know who they are and the people might change). In order so they are kept up to date of what changes have happened to the workbook though, I would like to input a 'changelog' that automatically opens when they open the excel file. However, I am not planning on making many changes in the future, and so I would like the userform to only appear for say 40 days, and then disappear.
Is this possible?
The icing on the cake would be a count down in days until the message disappears...!
The basic code I've got to open the userform is:
VBA Code:
Option Explicit
Private Sub Workbook_open()
Changelog.Show
End Sub