jFreezePanes()

Function Summary

The jFreezePanes function freezes a designated pane so the user can scroll through data and still keep the frozen pane in view. The function also hides a designated range of the report, typically the configuration section of an Interject report. This provides the user with a more user-friendly simplified viewing experience.

This action can be triggered by the Freeze/UnFreeze Panes found in Quick Tools on the Interject Ribbon Menu. There is also an option there to Freeze All Tabs, which will freeze all sheets containing the jFreezePanes function (it will not unfreeze the panes).

For an example of this function, see Lab Create: Customer Aging.

Function Arguments

FreezePanesCell
A range of cells, the first row of which will be used as the last row frozen in place. All rows after this row will be unfrozen and able to scroll freely after a freeze panes action. This is typically the header row of column names above the targeted data that is or will be inserted. This will allow the header row to stay in view while scrolling through the data. Best practice is to use a range instead of whole rows.

AnchorViewCell
A range of cells, the first row of which will be the top most displayed row after a freeze panes action. This is typically the row just below the Interject's configuration area. Best practice is to use a range instead of whole rows.

Excel Formula Bar Example

=jFreezePanes(A21,A15)

Function Composition