Changing frozen headers while scrolling

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

TheCornjerker - 12 Jan 2008 16:48 GMT

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

Reply to this Message

Sandy Mann - 12 Jan 2008 19:23 GMT

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

Signature

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

sandymann2@mailinator.com
Replace @mailinator.com with @tiscali.co.uk

> Hi,
>
[quoted text clipped - 26 lines]
> Thanks,
> C

Reply to this Message

TheCornjerker - 12 Jan 2008 19:49 GMT

> If you could do it, how would you scroll back up with frozen panes?
>
[quoted text clipped - 39 lines]
>
> - 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.

Reply to this Message

Earl Kiosterud - 13 Jan 2008 01:34 GMT

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.

Signature

Regards from Virginia Beach,

Earl Kiosterud
www.smokeylake.com

-----------------------------------------------------------------------

> Hi,
>
[quoted text clipped - 26 lines]
> Thanks,
> C

Reply to this Message