Freezing a Combo Box to a specific location on the Spreadsheet

[Papa_Don]

Group,

I've got multiple combo boxes spread out within a single worksheet. These will hide and unhide by section as check boxes are checked and un-checked. I need to ensure these combo boxes remain in their "assigned" locations as the rows hide and unhide with the changes of the check boxes. Is there a way to "assign" the combo box a specific location to live in to ensure it stays there?

Thanks for your help.

Don

 

[Sektor]

Right-click on combo and go to Properties. The last tab will reveal options you need.

 

[Papa_Don]

I'm using an ActiveX combo box. Therefore the Properties page lists the settings alphabetically or by Category. I'm unsure as to which settings will specifically assign the location.

 

[Sektor]

The lowest item in right-click menu.