View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.programming
Norman Jones Norman Jones is offline
external usenet poster
 
Posts: 5,302
Default Date last modified macro

Hi Leon,

You also have a response to your post in Excel.


---
Regards,
Norman


"Leon" wrote in message
oups.com...
Hi guys,

I am wondering if there is a function or maro i can write in excel that
can show the date my .xls fle was last modified?

So i need it to only change when any cells are changed with in the
workbook but if the workbook is opened and just viewed at, the date
will not change. I know that information is in the properties of the
file but i need it to get that info and put it in a cell.

Thanks for the help.