| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
How do you reference the logged on user name in excel?
I am making a template that sever users will be using this & I don't know how
to automatically put the logged in users name into the header. Can someone help with this??? |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
How do you reference the logged on user name in excel?
Hello Taurus, The name of the current user can be returned using Application.UserName. There are 3 headers on each Worksheet, Left, Center, and Right. These are accessed through PageSetup. Example for Left Header: Worksheets("Sheet1").PageSetup.LeftHeader = Application.UserName Example for Center Header: Worksheets("Sheet1").PageSetup.CenterHeader = Application.UserName Example for Right Header: Worksheets("Sheet1").PageSetup.RightHeader = Application.UserName Remember this has to be done to each sheet you want a header to appear on. Replace "Sheet1" in the examples with the name of Worksheet that will have a header. Sincerely, Leith Ross -- Leith Ross ------------------------------------------------------------------------ Leith Ross's Profile: http://www.excelforum.com/member.php...o&userid=18465 View this thread: http://www.excelforum.com/showthread...hreadid=504577 |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
How do you reference the logged on user name in excel?
Leith,
Is this using the VBA part of excel? I am pretty much a newbie in that. I have written any type of VB code in a while... I will try to keep at it but s far I am unsuccsessful. Sincerely, Taurus. "Leith Ross" wrote: Hello Taurus, The name of the current user can be returned using Application.UserName. There are 3 headers on each Worksheet, Left, Center, and Right. These are accessed through PageSetup. Example for Left Header: Worksheets("Sheet1").PageSetup.LeftHeader = Application.UserName Example for Center Header: Worksheets("Sheet1").PageSetup.CenterHeader = Application.UserName Example for Right Header: Worksheets("Sheet1").PageSetup.RightHeader = Application.UserName Remember this has to be done to each sheet you want a header to appear on. Replace "Sheet1" in the examples with the name of Worksheet that will have a header. Sincerely, Leith Ross -- Leith Ross ------------------------------------------------------------------------ Leith Ross's Profile: http://www.excelforum.com/member.php...o&userid=18465 View this thread: http://www.excelforum.com/showthread...hreadid=504577 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Excel file opened as read-only, if saved by another user | Excel Discussion (Misc queries) | |||
| Can excel files be opened in fixed screen size preset by user? | Excel Discussion (Misc queries) | |||
| Final week - 2005 Excel User Conference - Ft. Worth, Texas - Sept 16/17 | Excel Discussion (Misc queries) | |||
| Final week - 2005 Excel User Conference - Ft. Worth, Texas - Sept 16/17 | Excel Worksheet Functions | |||
| Formula for Excel User Name | Excel Worksheet Functions | |||
Linear Mode
