multiple split box's or freeze panes

[John Gallo]

Hello,

Any Excel wizards out there?

I dig the split box and freeze frame functions, but they
are apparently limited. Is there any way to keep four or
so rows at the top of the spreadsheet, and ALSO keep four
or so rows (the "totals") at the bottom? I.e. if we could
do a freeze frame for the top rows and a split box for the
bottow, it would work. But it seems that once you do one,
you cannot do the other. Are there any plug ins or tricks
to this?

Thanks,

John

 

[J.E. McGimpsey]

I don't know of any plug-ins or tricks that can do this, but you can
choose New Window from the window menu and position the windows one
above the other.

The windows won't scroll together, though you could accomplish that
using VBA event macros.

 

[John Gallo]

Thanks J.E.

Its a good idea, although I don't know VBA. I doubt it
is straightforward.

I guess I'll just put the totals up at the top, underneath
the headings. not very good way to present the info, but
I guess it works.

-JG

 

[John GAllo]

Hi J.E.

Actually, cancel that last message. I am going to try to
give it a shot. But I can't find the "event macros"
section in the VBA editor. Can you give me a tip on how
to get started?

Thanks,

JOhn

 

[Dave Peterson]

This might make you life easier:

http://support.microsoft.com/default.aspx?scid=kb;en-us;Q119718
XL: Can't Synchronize Windows By Choosing Arrange All

Look for: Visual Basic Macro

 

[J.E. McGimpsey]

Thanks, Dave - I couldn't find the KB article for some reason.