Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Worksheet Properties - Last User
Hi
The PC I use is part of an network that requires individuals to log on with their own personal log-on. ie: QWCAL when starting the computer. What is would like is some VB that would return the log-in of the last person to save the file. Any help is much appreciated John |
#2
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Worksheet Properties - Last User
John
Private Sub Workbook_BeforeSave(ByVal SaveAsUI _ As Boolean, Cancel As Boolean) With ThisWorkbook With Worksheets("Sheet1") .Range("A1").Value = "Last Saved By " _ & Environ("UserName") & " " & Now End With End With End Sub Gord Dibben MS Excel MVP On Thu, 10 May 2007 16:26:01 -0700, John Calder wrote: Hi The PC I use is part of an network that requires individuals to log on with their own personal log-on. ie: QWCAL when starting the computer. What is would like is some VB that would return the log-in of the last person to save the file. Any help is much appreciated John |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Setting format properties when opening Worksheet | Excel Worksheet Functions | |||
Microsoft Excel Worksheet Properties | Excel Worksheet Functions | |||
How to control chart properties from worksheet | Excel Discussion (Misc queries) | |||
How to control chart properties from worksheet | Charts and Charting in Excel | |||
Use of file properties in fields in worksheet | Excel Discussion (Misc queries) |