Display the users name when the document is printed.

[taylo40]

Can anyone help ?

The company I am working for is interested in printing the users name when the Excel spreadsheet is printed. The users name will appear in the footer of the spreadsheet.

The name should be mandatory.

The reason for the question is that if there is a solution for the question, if a document is printed without authorisation, the business will know the source.

Hope this makes sense.

J

 

[MJPPaba]

in the VBeditor locate the ThisWorkbook object and edit the code behind it. paste the following to this code sheet

Private Sub Workbook_BeforePrint(Cancel As Boolean)
ActiveSheet.PageSetup.LeftHeader = Application.UserName
End Sub

Matthew

crazy times call for crazy people


CrazyPabs


sometimes I wonder why I even bova...

 

[Loomah]

Hi
As Application.username can easily be changed (TOOLS>OPTIONS), depending on how important this requirement is I'd suggest using
environ("username")
in replace of application.username in Matthew's solutions above.

;-)

If a man says something and there are no women there to hear him, is he still wrong?
How do I get the best answers?​

 

[fumei]

I agree qwith Loomah. Environ("username") picks up the network logon name. NOTE: this is a environment variable and MUST exist in the environment varaiable collection in order to be used. However, if people are on a network this is pretty much a given.

Gerry

 

[taylo40]

Thanks Chaps