ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   dynamically enter name of last modified by in spreadsheet on save (https://www.excelbanter.com/excel-discussion-misc-queries/32835-dynamically-enter-name-last-modified-spreadsheet-save.html)

HW June 28th 05 05:04 PM

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.

Jim Rech June 28th 05 06:15 PM

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.




All times are GMT +1. The time now is 06:17 PM.

Powered by vBulletin® Copyright ©2000 - 2021, Jelsoft Enterprises Ltd.
ExcelBanter.com