vba -count number of disbled command buttons

[vlady]

Hello everyone,
I have a worksheet that has 5 command buttons
once click the button will be disabled.

the problem is how to count the disabled command button.
if there are 3 disabled command button a message box should appear stating that i've "Reached the maximum number to click".
Attached is the excel fie. ( 2003)

I hope someone can help me.

[pike]

hi vlady

something like..

Please Login or Register  to view this content.

[vlady]

Hello pike.

Yes that's it. Thanks a lot.
You saved my day.
The Oleobject declaration didn't come to my mind.

[pike]

If you are satisfied with the solution(s) provided, please mark your thread as Solved.

How to mark a thread Solved
Go to the first post
Click edit
Click Go Advanced
Just below the word Title you will see a dropdown with the word No prefix.
Change to Solved
Click Save