• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 878
  • Last Modified:

Excel 2000 - Freeze Panes

I am recording a macro in Excel 2000.

I am able to invoke Panes that split the Sheet into quarters.

How to I programmatically MOVE the pane to a different row and column?

For example I want the first row and first column to remain FIXED while I scroll.
0
Tom Knowlton
Asked:
Tom Knowlton
  • 2
1 Solution
 
sebastienmCommented:
Hi,

You can use the Freeze Pan (menu Window > Freeze Pane) instead of the Split.
    Range("B2").Select
    ActiveWindow.FreezePanes = True

Regards,
Sebastien
0
 
sebastienmCommented:
Thanks for the points and grade,  knowlton.
Regards,
Sebastien
0
 
Tom KnowltonWeb developerAuthor Commented:
Don't mention it.  :)
0

Featured Post

Concerto Cloud for Software Providers & ISVs

Can Concerto Cloud Services help you focus on evolving your application offerings, while delivering the best cloud experience to your customers? From DevOps to revenue models and customer support, the answer is yes!

Learn how Concerto can help you.

  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now