View Single Post
  #6   Report Post  
Posted to microsoft.public.excel.programming
Carl Hartness[_2_] Carl Hartness[_2_] is offline
external usenet poster
 
Posts: 63
Default 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