Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Signing Spreadsheets
There used to be a way to put your name in Windows so that when a user
clicked on Help and About your name and log was there, is there a way to that in Excel? |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Signing Spreadsheets
Here is one way:
Private Declare Function apiGetUserName Lib "advapi32.dll" Alias _ "GetUserNameA" (ByVal lpBuffer As String, nSize As Long) As Long Function fOSUserName() As String ' Returns the network login name Dim lngLen As Long, lngX As Long Dim strUserName As String strUserName = String$(254, 0) lngLen = 255 lngX = apiGetUserName(strUserName, lngLen) If (lngX 0) Then fOSUserName = Left$(strUserName, lngLen - 1) Else fOSUserName = vbNullString End If End Function Note: it may NOT work as you wish...try it and see... Regards, Ryan--- -- RyGuy "Vercingetorix.XIII" wrote: There used to be a way to put your name in Windows so that when a user clicked on Help and About your name and log was there, is there a way to that in Excel? |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Signing Spreadsheets
"Vercingetorix.XIII" wrote in message ... There used to be a way to put your name in Windows so that when a user clicked on Help and About your name and log was there, is there a way to that in Excel? File Properties |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Signing Spreadsheets
thanks, this worked very well...
"Stephen Bye" wrote: "Vercingetorix.XIII" wrote in message ... There used to be a way to put your name in Windows so that when a user clicked on Help and About your name and log was there, is there a way to that in Excel? File Properties |
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Signing Spreadsheets
I had forgotten all about that one
"Vercingetorix.XIII" wrote: There used to be a way to put your name in Windows so that when a user clicked on Help and About your name and log was there, is there a way to that in Excel? |
#6
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Signing Spreadsheets
You didn't like this reply to your posting of yesterday?
Private Sub Workbook_Open() Sheets("Sheet1").Range("A1").Value _ = ActiveWorkbook.BuiltinDocumentProperties("Author") End Sub Gord Dibben MS Excel MVP On Wed, 24 Sep 2008 08:18:17 -0700, Vercingetorix.XIII wrote: There used to be a way to put your name in Windows so that when a user clicked on Help and About your name and log was there, is there a way to that in Excel? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Digitally signing VBA Project | Excel Discussion (Misc queries) | |||
signing in | Excel Worksheet Functions | |||
Data Recording Officer Signing In | Excel Discussion (Misc queries) | |||
Electronic signing for an Excel Spreadsheet | Excel Discussion (Misc queries) | |||
Routing and Signing Excel Spreadsheets | Excel Discussion (Misc queries) |