Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Add author in Excel 2007
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 -- -- Laura |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Add author in Excel 2007
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").V alue = 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] On Sun, 3 Jan 2010 15:13:01 -0800, lglenn wrote: 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 -- |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do I change the author of a spreadsheet in Excel 2007? | Excel Discussion (Misc queries) | |||
Excel author name | Excel Discussion (Misc queries) | |||
Is there an author field in Excel? | Excel Discussion (Misc queries) | |||
Is there an author field in Excel? | Excel Discussion (Misc queries) | |||
How do I change the author on an Excel spreadsheet? | Excel Discussion (Misc queries) |