Hide Command button - still use it
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
|