User name button access.
 

I have created a spreadsheet that resides on my clients side. It’s a
trading program that will log all his trades for the day. At the end
of the day he presses a button and a macro runs that updates his logs
as well as emails me one, When I receive it I will usually open it and
then manually save it where it belongs.

I know I could make a new button that you can click that will save the
file on my side but he will see it as well.

What I would love to be able to do is show a button based on what?
Username? Is that possible? Any ideas other than a button that is
called Admin or something like that but still that will show on his
side.

Thanks in advance.

Ken


--
sungen99
------------------------------------------------------------------------
sungen99's Profile: http://www.excelforum.com/member.php...fo&userid=9144
View this thread: http://www.excelforum.com/showthread...hreadid=392943

User name button access.
 

Bump. Any ideas

--
sungen9
-----------------------------------------------------------------------
sungen99's Profile: http://www.excelforum.com/member.php...nfo&userid=914
View this thread: http://www.excelforum.com/showthread.php?threadid=39294

User name button access.
 

I think you are looking for "user" or "user name"... to make the button
visible.

MsgBox Application.UserName

Another way is to put the code into your Personal.xls.

--
steveB

Remove "AYN" from email to respond
"sungen99" wrote in
message ...

I have created a spreadsheet that resides on my clients side. It's a
trading program that will log all his trades for the day. At the end
of the day he presses a button and a macro runs that updates his logs
as well as emails me one, When I receive it I will usually open it and
then manually save it where it belongs.

I know I could make a new button that you can click that will save the
file on my side but he will see it as well.

What I would love to be able to do is show a button based on what?
Username? Is that possible? Any ideas other than a button that is
called Admin or something like that but still that will show on his
side.

Thanks in advance.

Ken


--
sungen99
------------------------------------------------------------------------
sungen99's Profile:
http://www.excelforum.com/member.php...fo&userid=9144
View this thread: http://www.excelforum.com/showthread...hreadid=392943