Add author in Excel 2007

  • Thread starter Thread starter lglenn
  • Start date Start date
L

lglenn

I teach at a suburban St. Louis high school in which students login using
Novell. In the past, we were able to go to the program file and in properties
add as "author" the computer name. I have tried doing that in Office 2007 as
well as through the Options tool bar under the Microsoft Window as an
administrator but it doesn't stay when students login and save their work.
Being able to do this, helps us identify students who share work. Does any
one have any ideas how to get this to work both in Word and Excel?

Thank you
 
In the ThisWorkbook module of the VBProject, insert the following
code:

Private Sub Workbook_BeforeSave(ByVal SaveAsUI As Boolean, Cancel As
Boolean)
ThisWorkbook.BuiltinDocumentProperties("Author").Value =
Environ("UserName")
End Sub

This will put the user's logon name in the Auithor field.

Cordially,
Chip Pearson
Microsoft MVP 1998 - 2010
Pearson Software Consulting, LLC
www.cpearson.com
[email on web site]
 
Back
Top