Hide Command button - still use it
On Mar 5, 8:29*pm, Carl Hartness wrote:
It's not very transportable, but I hide/unhide stuff based on my
username.
If Environ("username") = "myUserName" Then do something.
I have two PC's with different usernames, and so have to check for
both names.
If you used a common name like "user", then you can check for your
specific PC with
If Environ("computername")="yourPCsName" then do something.
Carl.
On Mar 5, 6:09*am, Madiya wrote:
I have a command button in addin which when clicked, shows the data on
a very hidden sheet.
I want to hide this button so that users can not see or use them.
At the same time I want to use it myself as and when required for
cross checking the data.
If I hide it, I am unable to use it.
Is it possible?
Regards,
Madiya- Hide quoted text -
- Show quoted text -
Sorry for delay in reply since I was out of office.
Mini Master,
Thanks for your help.
This is exactly what I wanted.
Carl,
Thanks but this not going to be usefull as I am taking the users
machine on remot due to which user name remains the same while I start
debuging.
But still thanks for trying to help me out.
Regards,
Madiya
|