Auto-Insert Last Date Edited

[Anita Taylor]

Is there anyway to automatically insert into a cell or the header/footer the
date a spreadsheet was last edited? Word has a built-in field for this and I
was hoping to find something similar in Excel.

 

[Ron de Bruin]

Hi Anita

You need VBA to do this

See the example on this page
http://www.rondebruin.nl/print.htm#Saved

 

[Anita Taylor]

I am using Excel 2000. I cannot copy/paste into the Visual Basic Editor.

 

[Ron de Bruin]

Hi Anita

Why not ?

Errors ?
VBA Protected ?

 

[Anita Taylor]

I see it now - the workbook is shared. That's the problem.

 

[Ron de Bruin]

Thanks for the feedback