'3.select the right cell to apply the freeze panes (freeze will follow the top left limits of that cell) '2.scroll up to the row that must be saved as the first in the window or window pane expand all the groups in the active sheetĪ RowLevels:=8, ColumnLevels:=8 'Expand all levels 'correct steps to freeze panes programmatically with vba They will both be visible regardless of where. All the rows above the cell and all the columns left of the cell will stay frozen. For this, you will need to select the upper left cell in the data which doesn’t require freezing. So I made a little research on the web and was trying several options until I've got it. In case you want to freeze the rows and columns simultaneously, you can do that too. Therefore, at the very moment that my freeze panes function was "shooting", the top 10 rows of my worksheet were actually out of the visible range (of course, everything inside a routine running as fast as the wind and with excel powers -such as screen updating- being turned off etc.) which caused an issue because these rows always remained like blocked out of the visible range after running the procedure.
#Freeze the first column in excel 2011 for mac code#
My problem was that in the moment that my code was trying to freeze the window in panes, the groups moved around without myself having noticed it. I have spent more than an entire hour to understand what was wrong with my code, and finally I think I've got it. Coding with both a structured worksheet (with rows and/or columns grouped) may be tricky.
0 kommentar(er)
