Auto-Insert Last Date Edited

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.

Hi Anita

You need VBA to do this

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


--
Regards Ron de Bruin
http://www.rondebruin.nl



"Anita Taylor" <AnitaTaylor@discussions.microsoft.com> wrote in message news:CC07C1D3-40D2-40CB-8425-7B34369C2CA7@microsoft.com...
> 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.

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

Hi Anita

Why not ?

Errors ?
VBA Protected ?

--
Regards Ron de Bruin
http://www.rondebruin.nl



"Anita Taylor" <AnitaTaylor@discussions.microsoft.com> wrote in message news:B4E3EFE0-2A87-4BF5-A9D9-1E735D7D045A@microsoft.com...
>I am using Excel 2000. I cannot copy/paste into the Visual Basic Editor.
>

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

Thanks for the feedback

--
Regards Ron de Bruin
http://www.rondebruin.nl



"Anita Taylor" <AnitaTaylor@discussions.microsoft.com> wrote in message news:AAD54532-FD43-4B6D-B128-9821E4BB2D6D@microsoft.com...
>I see it now - the workbook is shared. That's the problem.