Home |
Search |
Today's Posts |
#1
|
|||
|
|||
insert a user's name/id
I am aware of functions like =TODAY() which will automatically insert today's
date into a cell. I was wondering if something similar existed for user ID's/name. When you create a new spreadsheet it bears the name of the user who first created it in the properties. Is there a function I can put in a cell that will show the user name/id who has opened or last mondified the file (for example)? Thanks. |
#2
|
|||
|
|||
not that i know of but you can do it with code. here is
some code we use in some of our files to keep a record of who opened a file, when and how long they were in it. to add code: alt+F11. copy and paste this code in the this work book module. the code wrapped when i pasted it here. it should be 4 lines each sub with each line starting with sheetes. otherwise you made get errors. Private Sub Workbook_BeforeClose(Cancel As Boolean) Sheets("Formula").Range("IT2").End(xlDown).Offset( 1, 0).FormulaR1C1 = Now() Sheets("Formula").Range("IT2").End(xlDown).Offset( 1, 0).Copy Sheets("Formula").Range("IT2").End(xlDown).Offset( 1, 0).PasteSpecial Paste:=xlValues Sheets("Formula").Range("IT2").End(xlDown).Offset( 0, 1).FormulaR1C1 = Application.UserName End Sub Private Sub Workbook_Open() Sheets("Formula").Range("IQ2").End(xlDown).Offset( 1, 0).FormulaR1C1 = Now() Sheets("Formula").Range("IQ2").End(xlDown).Offset( 1, 0).Copy Sheets("Formula").Range("IQ2").End(xlDown).Offset( 1, 0).PasteSpecial Paste:=xlValues Sheets("Formula").Range("IQ2").End(xlDown).Offset( 0, 1).FormulaR1C1 = Application.UserName End Sub -----Original Message----- I am aware of functions like =TODAY() which will automatically insert today's date into a cell. I was wondering if something similar existed for user ID's/name. When you create a new spreadsheet it bears the name of the user who first created it in the properties. Is there a function I can put in a cell that will show the user name/id who has opened or last mondified the file (for example)? Thanks. . |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
insert a JPEG into EXCEL 2002 | Excel Discussion (Misc queries) | |||
Challenging Charting | Charts and Charting in Excel | |||
How do I insert an image into a specific cell within a protected . | Excel Discussion (Misc queries) | |||
insert worksheet gives me 3 duplicate sheets not one | Excel Discussion (Misc queries) | |||
Insert symbol menu | Excel Discussion (Misc queries) |