Does that equate to the person submitting to print with the name
they want to use --- application.username
or are you trying to do something for security purposes as to who
printed it from a network logon, a little less beyond their control
(printing easily bypassed/modified).
Some references on my site:
http://www.mvps.org/dmcritchie/excel/userid.htm
http://www.mvps.org/dmcritchie/excel/pathname.htm
http://www.mvps.org/dmcritchie/excel/property.htm
My own choice would be installing a macro to be invoked by user
before printing. I prefer this to automatically including when printing
anything because one might occasionally print someone else's
material or want a different format..
Header
left: (blank)
middle: title
right: username
Footer
left: full pathname -- modified for readability
middle: Page x of xx
right: date and time as in yyyy-mm-dd hh:mm
Read about the following code with your modification to include username
http://www.mvps.org/dmcritchie/excel/pathname.htm#footer
I would assign the following code to a toolbar button (smilyface)
Sub PutFileNameInFooter()
'Documented in http://www.mvps.org/dmcritchie/excel/pathname.htm
'alternative -- lowercase for pathname Sheetname as is within square brackets
'also using an 8 point font, lettercase of Sheetname is unchanged in this
'example because you have control and can change it within the workbookbook
'Use of WITH provide a prefix for names that begin with a period
With ActiveSheet.PageSetup
'-- modified to include username -- special request 2006-01-30
.RightHeader = application.username
.LeftFooter = "&8" & _
LCase(Application.ActiveWorkbook.FullName) & " &A "
If .RightFooter = "" Then .RightFooter = "Page &P of &N"
End With
End Sub
If unfamiliar with macros see
http://www.mvps.org/dmcritchie/excel/getstarted.htm
for help in searching newsgroups
http://www.mvps.org/dmcritchie/excel/xlnews.htm
and use of your real name would be more friendly.
---
HTH,
David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001]
My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm
Search Page: http://www.mvps.org/dmcritchie/excel/search.htm
"dneal53" <dneal53[ at ]discussions.microsoft.com> wrote in message news:FF6CCEFB-DB3F-4D76-BB95-D35C7AFDED8F[ at ]microsoft.com...
[Quoted Text] > I have created a spreadsheet for my department to use to list their projects
> for each week. Just wondering if there is an automatic way to have the
> various author's names inserted in the footer or in a cell without them
> needing to do it. Any suggestions would be appreciated...
|