comparing commandbars

Can someone tell me why this doesn't work?

Please Login or Register  to view this content.

but this does work

Please Login or Register  to view this content.

The comparitive IS is a balky one. I only use it to test if somthing IS Nothing. Otherwise, I test a unique property to see if two objects are the same.
like your name test.

By the way, why loop? Wouldn't this do the same thing?

Please Login or Register  to view this content.

Hi Mike;

You're right. In this example, your code would be better.

But this isn't my real sub. I simplified it for the thread. In reality cbSelected is optional, and if no commandbar is passed then the sub works on all commandbars.

I use "is" to compare workbooks and worksheets and never had a problem. I would still like to know why it doesn't work with commandbars.