Freeze panes and worksheet_beforedoubleclick - Annoying automatic scrolling

[rodgersmg]

Good morning all!

I am working on a daily planning sheet where a doubleclick in a cell pulls up a listbox of tasks to be completed for that corresponding day. Items can be selected from the list and copied into the active cell.
I've frozen the panes in C6, and now whenever I double click a cell, it is automatically moved to the top left position (where C6 would be), and all cells between there and the cursor are highlighted.
Has anyone experienced this/heard of it happening?

There's an example workbook attached which might make the problem more understandable.

Michael

[rodgersmg]

Looks like I found the problem:

In the worksheet_beforedoubleclick event there was a line to make a listbox visible.
Removing that stopped everything scrolling all over the place, but I had a new problem that listbox.visible = False wold not work. The property would be changed to false, but the listbox would still be visible.
The only way I could find to work around that was to set the visibility at the start of the listbox_dblClick event as true, then set it to false again at the end.

Result: No unwanted scrolling/cell selection, and listbox comes and goes when it should.

I'd still be interested to know if anyone else has experienced anything similar/found different solutions though!

EDIT:Sorry, not solved yet.. obviously now I can't see the listbox at all because I can't doubleclick it to make it visible...
EDIT 2: Last Edit invalid - Having listbox.activate in the worksheet_beforedoubleclick event makes it visible too...