DenisBallant
New Member
- Joined
- Aug 31, 2006
- Messages
- 6
Could anyone tell me whether it's possible to programmatically select a cell without resetting the positions of the frozen panes.
For instance I have frozen panes both horizontally and vertically (A-E, F-) and the second vertical pane is currently showing columns J-L. If I select any cell in the first vertical pane programmatically, the second vertical pane is reset and now shows columns F-H. I would like that the second pane keeps showing columns J-L. Only if a cell in 2nd vertical pane is selected which is currently not visible, selection should make it visible on the screen.
Any help appreciated.
Denis
For instance I have frozen panes both horizontally and vertically (A-E, F-) and the second vertical pane is currently showing columns J-L. If I select any cell in the first vertical pane programmatically, the second vertical pane is reset and now shows columns F-H. I would like that the second pane keeps showing columns J-L. Only if a cell in 2nd vertical pane is selected which is currently not visible, selection should make it visible on the screen.
Any help appreciated.
Denis