Hi Donald,
This works for me
Private Sub Workbook_BeforePrint(Cancel As Boolean)
With ActiveSheet
.PageSetup.LeftFooter= Application.UserName
End With
End Sub
--
HTH
Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)
"Donald Stockton" wrote in message
...
I'm trying to use <application.username in a footer, but seems that it
is only printing out as text [application.username] and not the actual
User's Name. Can this be done?
D.S.
*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!