Logo 
Search:

MS Office Forum

Ask Question   UnAnswered
Home » Forum » MS Office       RSS Feeds

Excel 2000 - FreezPanes

  Asked By: Qadriyah    Date: Mar 13    Category: MS Office    Views: 1102
  

I want to do an unfreezepanes and a freezepanes in VBA. When I try to
record a macro for this it comes up empty.

There is a freezepanes in the object browser as a method of the
windows object but then I have to know which window I'm freezing
in!!.. and guess what.. I don't know how to do that!

Share: 

 

1 Answer Found

 
Answer #1    Answered By: Dang Tran     Answered On: Mar 13


When you record the macro, do something between freezing and
unfreezing the panes like select a different cell, then you'll get
something like this:
Range("D6").Select
ActiveWindow.FreezePanes = True
Range("F11").Select
ActiveCell.FormulaR1C1 = "33"
Range("F12").Select
ActiveWindow.FreezePanes = False
Range("G12").Select
ActiveWindow.FreezePanes = True

 
Didn't find what you were looking for? Find more on Excel 2000 - FreezPanes Or get search suggestion and latest updates.




Tagged: