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?

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?

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

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

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?

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?