| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
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. |
|
#2
|
|||
|
|||
|
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" wrote in message ... 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. |
|
#3
|
|||
|
|||
|
I am using Excel 2000. I cannot copy/paste into the Visual Basic Editor.
|
|
#4
|
|||
|
|||
|
Hi Anita
Why not ? Errors ? VBA Protected ? -- Regards Ron de Bruin http://www.rondebruin.nl "Anita Taylor" wrote in message ... I am using Excel 2000. I cannot copy/paste into the Visual Basic Editor. |
|
#6
|
|||
|
|||
|
Thanks for the feedback
-- Regards Ron de Bruin http://www.rondebruin.nl "Anita Taylor" wrote in message ... I see it now - the workbook is shared. That's the problem. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Insert date in macro | New Users to Excel | |||
| Making a auto date entered into a cell permanent from a template | Excel Discussion (Misc queries) | |||
| auto dating after entering the first date | Excel Worksheet Functions | |||
| Automatically Insert DATE, so that DATE will NOT change | Excel Worksheet Functions | |||
| Challenging Charting | Charts and Charting in Excel | |||
Linear Mode
