Display Date in Spreadsheet

L

Liz

Hello,

I want to display the date that I last saved the spreadsheet. Is this
possible and how do I do this? I have Excel 2002.

Thanks!
 
C

CyberTaz

Hi Liz -

First, this is the newsgroup for Mac XL - 2002 (XP) is a Windows version,
but the general response will be roughly the same.

If this is just something that you want to check from time to time you can
easily go to File>Properties>General where the Modification Date is tracked
for you automatically.

If there is some reason you need to have this constantly displayed or
available for calculations, I believe you will need to employ some VBA.
Since there is somewhat of a difference Mac/Windows you might want to post
the question in the Windows XL group, although most of the other MVPs here
work both sides of the street. Actually, I do too, but VBA just ain't my
strong suit :)
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top