Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.setup
|
|||
|
|||
Excel and Windows Login ID problem...
I need to know if there is a function that will allow an excel spreadsheet
cell to automatically populate itself with the login id of the person using the computer? Example of how I would like it to work.... 1. A person opens a spreadsheet 2. And bam!! Cell A1 shows their windows login id |
#2
Posted to microsoft.public.excel.setup
|
|||
|
|||
Excel and Windows Login ID problem...
Tad
Try this in the ThisWorkbook module (To implement right click the lower of the two Excel icons, top left of the window and select view code, paste here and close out) it will place the Username in cell A1 on sheet1...Bam! Private Sub Workbook_Open() Worksheets("Sheet1").Range("A1").Value = Environ("Username") End Sub -- HTH Nick Hodge Microsoft MVP - Excel Southampton, England DTHIS www.nickhodge.co.uk "Tad Anglin" wrote in message ... I need to know if there is a function that will allow an excel spreadsheet cell to automatically populate itself with the login id of the person using the computer? Example of how I would like it to work.... 1. A person opens a spreadsheet 2. And bam!! Cell A1 shows their windows login id |
#3
Posted to microsoft.public.excel.setup
|
|||
|
|||
Excel and Windows Login ID problem...
Nick....
Thanks for taking some time out of your day...that worked beautifully. BAM! "Nick Hodge" wrote: Tad Try this in the ThisWorkbook module (To implement right click the lower of the two Excel icons, top left of the window and select view code, paste here and close out) it will place the Username in cell A1 on sheet1...Bam! Private Sub Workbook_Open() Worksheets("Sheet1").Range("A1").Value = Environ("Username") End Sub -- HTH Nick Hodge Microsoft MVP - Excel Southampton, England DTHIS www.nickhodge.co.uk "Tad Anglin" wrote in message ... I need to know if there is a function that will allow an excel spreadsheet cell to automatically populate itself with the login id of the person using the computer? Example of how I would like it to work.... 1. A person opens a spreadsheet 2. And bam!! Cell A1 shows their windows login id |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
TRYING TO SET UP EXCEL SPREADSHEET ON MY COMPUTER | New Users to Excel | |||
Problem exporting to excel with Windows XP | Excel Discussion (Misc queries) | |||
Excel 2003 Slowness problem in Windows XP | Excel Discussion (Misc queries) | |||
open separate exterior excel windows | Excel Discussion (Misc queries) | |||
Problem opening Excel files from Windows Explorer | Excel Discussion (Misc queries) |