Hi
As part of the macro that runs from the button, ask for a password.
Insert

pw = inputbox("Password required")
If pw = "mypassword" then
'run rest of sub
end if

not as elegent as hiding the button but easier.
regards
Paul

On Mar 5, 1:20*pm, Madiya wrote:
On Mar 5, 5:39*pm, wrote:





Hi
If the command is on a toolbar simply comment out the code that adds
it to the toolbar (maybe in the Workbook Open macro of your AddIn?).
Distribute this version of the AddIn to your users.
regards
Paul

On Mar 5, 12:09*pm, 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 -

This button is on user form.
Any other thoughts?
Regards,
Madiya- Hide quoted text -

- Show quoted text -