I have a worksheet that I'd like to modify to be able to scroll a certin
number of lines before changing where the freeze is located.
I'm using Excel 2003
ie..

My sheet is less than 200 rows long.
The top 5 rows are frozen.
There is a header so to speak on row 47 that when I scroll down to it I
would then like to freeze from there up.
On scrolling back upwards I'd like to change the freeze back to line 5.
I've looked around and can find no reference to this, but it seems so
simple.

I'd like to thank all who respond before hand!

Barry