Kelly,

Excel is by no means secure and any protection scheme that
you try to implement can be circumvented by an experienced user.

Your original question was to find the UserName which I think
has been answered (as for the initials with a middle initial, that can
be done also) but now I get the impression that you're looking at this
from a security issue??

One of the best ways (though still not secure) would be to test
against the Hard Disk Drive Serial Number.

If you'd like, I can supply some code to do this.

John

Kelly wrote:

Thanks to you both. Your advice did help me to understand
a little better but unfortunaly (or fortunaltley depending
how you look at it) I also now relize the code I build is
not as secure or as reliable as I firt thought.

First of all good advice Jhon but I need all three
initials and it appears company standards were to only
enter the first and last name of the employee when
installing Office.

Secondly I found a way to break into my spreadsheet to
read information that was not meant for me.

See the way I had set it up is that when you opened the
template it would automaticly find the Application .user
and based on this prefor a bunch of V-look ups on a
verryhidden conrtol sheet. Now I realize that the user
only has to change the info in his General options to look
at other users info.

I know that it is not real secure as a hidden sheet but I
think more so then this. Also I did a little testing and
if there is even an extra space in the info under general
options then the v-lookup crashes.

As far as the initals, I just added anonther column to my
hidden sheet and added another v-lookup to access the
initials but I am a little worried about the other issues
now.

Any other suggestions as to how to return PC user
information? I would like to be able to referance the
users Windows log-on ID but have no idea to do that?

Thanks for all your help.

Kelly

-----Original 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
.