Add author in Excel 2007


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
 
Ad

Advertisements

C

Chip Pearson

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]
 

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

Top