dynamically enter name of last modified by in spreadsheet on save

G

Guest

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.
 
J

Jim Rech

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
| 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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Last Modified By in a cell by user 3
Date last modified - for entire workbook 3
Last Modified time... 1
Urgent help needed please 5
Global Header Setting 1
Last name True won't format 2
How do I enter the date last modified in the footer of an Excel d. 1
Tracking "Date Last Saved" 1

Top