ActiveX List Box and Freeze Panes

[Swetz]

I've been working on a Survey template for a project at work. The workbook has multiple worksheets (1 for each question) and a series of repeating List Boxes for responses corresponding to multiple locations. Each list box is populated from a static named range on another worksheet. Intermittently, when I initially navigate to a sheet some of the list boxes that were not immediately visible behave as if they are not enabled. If I activate another sheet and return, presto the previously unresponsive list boxes work.

After much frustration and googling, it appears that the issue is tied to the freeze panes I had set on the sheets. I found a couple other forum threads (http://www.mrexcel.com/forum/excel-...oxes-not-able-clicked-into-when-revealed.html and Unresponding ListBox on a worksheet (XL2003) | Windows Secrets Lounge) describing the same type of behavior. Some suggest turning the freeze panes off initially and adding it as part of the worksheet activate event.

I just wondered if anyone else had encountered this issue in the past and if so, what was the resolution. I can certainly just remove the freeze panes or perhaps experiment with dynamically adding it as suggested in one of the previous threads, but would prefer a more elegant solution if possible.

Thanks.