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.
