Home |
Search |
Today's Posts |
#1
|
|||
|
|||
dynamically enter name of last modified by in spreadsheet on save
Is there a way to have excel change the name in the footer of a spreadsheet
to the name of the person who last modified the the spreadsheet and also the time of the last change. Not the time it was last viewed... but specifically modified. |
#2
|
|||
|
|||
You could write code for the BeforeSave event (more on that can be found in
online VBA help) to change the footer. That would assume that the user enabled macros when the workbook was opened. If he didn't then no macros will run and you cannot enforce this. -- Jim "HW" wrote in message ... | Is there a way to have excel change the name in the footer of a spreadsheet | to the name of the person who last modified the the spreadsheet and also the | time of the last change. Not the time it was last viewed... but specifically | modified. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
enter data on 1 sheet and make it enter on next avail row on 2nd s | Excel Discussion (Misc queries) | |||
Is there way to enter multiple values into excel cells w/ a form? | Excel Discussion (Misc queries) | |||
Is there a (non-binary) "if x then enter y" forumula? | Excel Worksheet Functions | |||
How do I enter a negative dollar amount? | Excel Discussion (Misc queries) | |||
How do I enter the date last modified in the footer of an Excel d. | Excel Discussion (Misc queries) |