I have a very wide DW, where I want the user to be able to continually see the first two columns, while scrolling horizontally to see the rest of the columns. That is exactly what Excel's Freeze Panes feature allows.
What I have come up with so far is:
dw1.HSplitScroll = TRUE
dw1.Object.DataWindow.HorizontalScrollSplit = 1897 // width of first 2 columns
That puts in the splitter bar where I want it. But both the left and right sides can be scrolled to see all of the columns, which could be confusing to the users! I want the left side to be frozen (not scrollable) and the right size to not be able to be scrolled left back into the first two columns.
I have read the descriptions of the HorizontalScrollPosition, HorizontalScrollPosition2, HorizontalScrollMaximum and HorizontalScrollMaximum2 properties, and it does not appear that they will help in any way, to the best of my understanding of their descriptions. (I don't find those descriptions very clear at all, mind you.) I also looked at the ScrollHorizontal event.
Am I missing something? Is there some magic combination of the event and the properties that will allow me to prevent the scrolling in the left pane, and limit the scrolling in the right one?
Thanks.