Time messege in excel

[thunder_anger]

Hi guys

iam finishing an excel file here

and i wanted to put a touch in the file

so when you open the workbook a messege would popup ans say
"last time you opened the workbbok was "XXXX" days ago

is that possible

 

[thunder_anger]

any help????????

 

[asad]

I am not too sure, but I think you would need two VBA codes.

• One will be for logging in before file is closed evrytime so to keep record of last day and time the file was used.
• Second one will be a simple one to deduct the number of days e.g. today()-last day logged in.