Last Modified Date

**Jeskers31** · 08-31-2011, 02:48 PM

Hello-

I have created a form in Excel 2007 that multiple managers will be using. I would like to add the "Last Modified by User on Date & Time" as a footer. Is there a way to add this so that it updates ONLY when the document has been modified? I don't want it to update based on whent he document was last saved, but when any edits were made. Is it possible to add this as an auto populated field or will I have to manually update this?

Thanks,

**bentleybob** · 08-31-2011, 06:33 PM

I have the following code in my Book.xlt file, but you can add it to your file. It needs to be in "This WorkBook", not in a module. If the file is new, you might have to save it twice before it appears in the footer. It doesn't mention the User, just the date/time it was last updated.

Please Login or Register  to view this content.

**shg** · 08-31-2011, 09:34 PM

Please edit your post to add CODE tags.

Thanks.

Last Modified Date

LinkBack

Thread Tools

Rate This Thread

Display

Last Modified Date

Re: Last Modified Date

Re: Last Modified Date

Thread Information

Users Browsing this Thread

Bookmarks

Bookmarks

Posting Permissions