Only enable a command button on a userform for certain users

[Llamapoth]

I am trying to disable a user button so that only certain users can use it. I want it to be restricted on initialisation but to enable based on a listvof authorised users based on their system login ID but for the life of me cannot work out how to do it. Any help would be appreciated. Cannot post any code as companies IT policy prevents me accessing thus site Sorry!

 

[TonyUK72]

"SHEETNAME.COMMANDBUTTON.ENABLED = FALSE" or "TRUE"

is the VBA to either activate or deactivate the command button, you would need a little more code to check for authorised users etc. It will give you a start anyway.

 

[Llamapoth]

Thanks Tony I'll give it a go