Is it possible to display the current user name within a cell of the workbook?
C Chip Pearson Oct 31, 2005 #2 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
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
M maryj Nov 11, 2005 #3 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?
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?
