View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.programming
Richard Choate Richard Choate is offline
external usenet poster
 
Posts: 42
Default Returning User Initials

Some people make Excel utilities which will include new functions that you
can use just like the built-in Excel functions. One of these Utlilities is
the Power Utility Pack by John Walkenbach. Here is the link
http://www.j-walk.com/ss/pup/pup2000/index.htm This includes a function
called User(). This function returns the username described in my other
posted response. You can then nest the function into another function which
will give you the initials.

You can also create your own custom function for this and then nest that.
I'll help you if you want to go that route.

HTH
Richard Choate

"Kelly" wrote in message
...
Hi all, I am using the Office 2000 package

In Word VB you can return user initials
with "Application.UserInitials"

Is there any way to do this in Excel?

I know you can return user name
with "Application.UserName" but no luck with initials so
far.

Also Where does the user name info come from anyway?
In "Word" it is entered in tools/Options/UserInformation
but I have no idea for Excel.


Thanks as always!

Kelly