Posted 8 September 2017, 12:31 pm ESTHi,<br><br>I have got a unique requirement of fixing a couple of columns while using horizontal scrollbar of a grid. <br><br>Say I have got 30 columns in a grid and horizontal scrollbar is enabled. Whenever I use the horizontal scrollbar, the first 2 columns should be fixed and the other columns should start scrolling.<br><br>Thanks in advance.<br>Sagar.<br>
How to fix a column while using scrollbar?
Posted by: sagar-fp on 8 September 2017, 12:31 pm EST
Replied 8 September 2017, 12:31 pm ESTHello Sagar,<br><br>Setting FrozenColumnCount to two should work for you:<br> FpSpread1.Sheets(0).FrozenColumnCount = 2 <br><br>More information on freezing rows and columns can be found in your help.<br>