Hiding only certain form control buttons on a worksheet

I have a worksheet called Manager with many form control buttons. Most of these are available to the user, but others I do not want the user to see. I know I could hide specific activeX buttons, but have not been able to find any code or a way to hide specific form control buttons.

Does anyone have any suggestions?

No, just button form controls placed on a worksheet to initiate various routines, but I am open to any suggestions that may resolve the issue. I have about 20 buttons that are available to the user, and another 12 that previously were hidden when they were ActiveX controls. I have found code that will hide all the buttons, but that does not help. The 12 I want to hide allow access to routines that I do not want the user to see, such as unprotect worksheets, etc.

The button properties can be changed through VBA based on the button index number:

Please Login or Register  to view this content.

You can loop through the buttons on your worksheet by defining the button number. From there you can pull the properties and see if it is the button you want. For instance, below is a quick macro that will loop through 50 buttons, check to see if the buttons caption matches, and then change that button property to either visible or non visible.

Please Login or Register  to view this content.

-EDIT-

There is probably a more elegant way of doing this, but this method gets the job done.

Thank you frabulator. Where I went wrong was when assigning the name of the macro, instead of accepting the button number default, I was changing the name of the button. Once I realized that, I recreated the buttons and using your suggestion it works great.

Thanks again.