Is there a way to disable multiple buttons at one time?

I have a vba userForm that has 36 buttons on it. I would like to disable all buttons when a value on one of my spreadshets reaches a certain number. Right now with each click of a button a number goes up by one on the spreadsheet I'm referencing. When the number reaches three I would like to disable all buttons.

6
задан Mike 8 April 2011 в 16:12
поделиться