Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Old June 28th 05, 05:04 PM
HW
 
Posts: n/a
Default 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   Report Post  
Old June 28th 05, 06:15 PM
Jim Rech
 
Posts: n/a
Default

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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
enter data on 1 sheet and make it enter on next avail row on 2nd s Nadia Excel Discussion (Misc queries) 27 September 9th 05 03:39 PM
Is there way to enter multiple values into excel cells w/ a form? grassfed Excel Discussion (Misc queries) 1 June 22nd 05 05:26 PM
Is there a (non-binary) "if x then enter y" forumula? Julie P. Excel Worksheet Functions 9 June 21st 05 08:49 PM
How do I enter a negative dollar amount? CML Excel Discussion (Misc queries) 7 February 6th 05 11:19 PM
How do I enter the date last modified in the footer of an Excel d. Last modified date in footer Excel Discussion (Misc queries) 1 February 6th 05 11:12 PM


All times are GMT +1. The time now is 05:26 AM.

Powered by vBulletin® Copyright ©2000 - 2021, Jelsoft Enterprises Ltd.
Copyright 2004-2021 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"

 

Copyright © 2017