Hi guys. I hope there's an answer to this one.
I have a worksheet which demands panes to be frozen across both axes (select cell H11 then freeze panes). I also have a whole panel of ActiveX controls in the top-left corner (created at runtime with VBA, every time the document is generated).
I want my "control panel" to be wider than columns A-H. The control panel consists of many OLEObjects on top of a backing frame ("Forms.Frame.1"), with a coloured background. As I say, its width extends out to the right beyond Column H - however when the frames are frozen, and the user scrolls right, the section of the control panel right of the freeze line is taken as part of the scrolling!
I want a way to overlay the controls completely on top of the worksheet so that the fact that the underlying cells are frozen doesn't affect it.
Grateful for any suggestions!
I have a worksheet which demands panes to be frozen across both axes (select cell H11 then freeze panes). I also have a whole panel of ActiveX controls in the top-left corner (created at runtime with VBA, every time the document is generated).
I want my "control panel" to be wider than columns A-H. The control panel consists of many OLEObjects on top of a backing frame ("Forms.Frame.1"), with a coloured background. As I say, its width extends out to the right beyond Column H - however when the frames are frozen, and the user scrolls right, the section of the control panel right of the freeze line is taken as part of the scrolling!
I want a way to overlay the controls completely on top of the worksheet so that the fact that the underlying cells are frozen doesn't affect it.
Grateful for any suggestions!
