Hi All,
Long time listener first time caller.
I am trying to set a named range to the rowsource for a combo box based on the below code. It works fine if I have sheet 3 active, but does not work if I have any other sheet active. The trouble is that I do not want my users to see sheet3 at all. I would specifically like to make sheet3 veryhidden.
Can any of you propose modifications to my code so that it will work when sheet3 is a very hidden sheet?
Thanks in advance for your help,Please Login or Register to view this content.
Bookmarks