ComboBox Fails When Columns Are Hidden

Please see two attached files.

Combo Box Example1.xlsm works perfectly.
Combo Box Example2.xlsm does not work at all because the columns used by the ComboBox are hidden.

Here is the code:

Please Login or Register  to view this content.

Please Login or Register  to view this content.

My question: What must be done to allow the ComboBox to work while the color columns are hidden?

Your suggestions will be most appreciated!

tom

why don't you just add some code to un-hide the columns then hide them again when you are finished?

That's a thought, Sc0tt1e. But if there is a simple tweak of the properties or something, I would rather do that.

Sorry, I don't know of anything the properties could do to resolve this issue

I tried this and it worked perfectly

Please Login or Register  to view this content.

Thanks to ScOtt1e and Bakerman2!

There is indeed more than one way to skin a cat.

Thanks again for the help; I really appreciate it.

tom