Changing frozen headers while scrolling

[TheCornjerker]

Hi,

I have a situation where I'd like to change the freeze pane headers
when a scroll hits a certain line. For example:

FROZEN HEADER 1
data
data
data
data
FROZEN HEADER 2
data
data
data
data
FROZEN HEADER 3
data
data
data
.....

The data line extend off the bottom of the screen, but as the user
scrolls down the page, I'd like to change the header at the top of the
sheet. If I freeze "FROZEN HEADER 1" and the user scrolls down to the
data lines under "FROZEN HEADER 2", then the frozen header needs to
change to "FROZEN HEADER 2"

Is this possible with some setting or VBA?
Thanks,
C

 

[Sandy Mann]

If you could do it, how would you scroll back up with frozen panes?

--

Sandy
In Perth, the ancient capital of Scotland
and the crowning place of kings

(e-mail address removed)
Replace @mailinator.com with @tiscali.co.uk

 

[TheCornjerker]

If you could do it, how would you scroll back up with frozen panes?

--

Sandy
In Perth, the ancient capital of Scotland
and the crowning place of kings

(e-mail address removed)
Replace @mailinator.com with @tiscali.co.uk










- Show quoted text -

As you scoll backup, I need the reverse to happen. When you hit the
data at bottom of the header 1 secton, the header 1 would re-appear at
the top.

After a little more research, this doesn't look like a trivia task.
There doesn't seem to be an OnScroll event in Excel. There are some
hacks but nothing maintainable.

Oh well.

 

[Earl Kiosterud]

Corn,

It could probably be done with an event-fired macro that, when the user wants to have frozen
header 2 in place, turns off freeze panes, scrolls the sheet upwards until header 2 is at
the top of the screen, then turns on freeze panes again. One question would be how you want
it to be signaled to do this.