Home |
Search |
Today's Posts |
#1
|
|||
|
|||
How do I display the user details in a XLS sheet?
Is it possible to display the current user name within a cell of the workbook?
|
#2
|
|||
|
|||
How do I display the user details in a XLS sheet?
You can only do this with a VBA function.
Public Function UserName() UserName = Environ("username") End Function For more info about getting document properties in Excel, see www.cpearson.com/excel/docprop.htm -- Cordially, Chip Pearson Microsoft MVP - Excel Pearson Software Consulting, LLC www.cpearson.com "CJ" wrote in message ... Is it possible to display the current user name within a cell of the workbook? |
#3
|
|||
|
|||
How do I display the user details in a XLS sheet?
Where would you put this code - in the sheet, in a module or in the workbook?
I've tried pasting the code into various locations - I should be able to see the name of the function when I got into the Paste Function dialog box, user defined - right? -- maryj "Chip Pearson" wrote: You can only do this with a VBA function. Public Function UserName() UserName = Environ("username") End Function For more info about getting document properties in Excel, see www.cpearson.com/excel/docprop.htm -- Cordially, Chip Pearson Microsoft MVP - Excel Pearson Software Consulting, LLC www.cpearson.com "CJ" wrote in message ... Is it possible to display the current user name within a cell of the workbook? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Clicking Cell Link Changes Cell on Another Sheet | Excel Discussion (Misc queries) | |||
Subset of one sheet on another sheet | Excel Discussion (Misc queries) | |||
Worksheet won't display full screen | New Users to Excel | |||
Impoting data from Sheet 1 to Sheet 2 | Excel Discussion (Misc queries) | |||
Display summary sheet with Now or Today data. | New Users to Excel |