How do I do, when I print an excel file, to have the username or the computer
name of the person/computer that is printing it?
Thanks.
How do I do, when I print an excel file, to have the username or the computer
name of the person/computer that is printing it?
Thanks.
Good evening YesNo (????)
This macro, when called, will set the current username in the left hand footer on the page. This will need to be activated every time the file is opened to capture the current user - for compatability I have used the older auto_open procedure, but if you prefer you could run it from the workbook_open event procedure.
Sub auto_open()
For Each sht In ActiveWorkbook.Sheets
sht.PageSetup.LeftFooter = Application.UserName
Next sht
End Sub
HTH
DominicB
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks