Freeze Pane

[sheeeng]

Hi all, :hi:

Can anyone show me how to use Freeze Pane by Excel macro? :help

Thanks.

[macb]

Hi there:


Try this.



Sub Macro1()
'remove any previous freezing
ActiveWindow.FreezePanes = False
'Select the cell you want to start your freezing
ActiveWorkbook.Sheets("Sheet1").Range("B5").Activate
'apply freezing
ActiveWindow.FreezePanes = True

End Sub


Regards

Mac

[sheeeng]

Thanks. macb. :thumb
You had made this thread solved. :clap:

Can we just freeze only vertical or horizontal only? :help

Thanks:)

[Bob Phillips]

Thanks. macb. :thumb
You had made this thread solved. :clap:

Can we just freeze only vertical or horizontal only? :help

Thanks:)

Just selct column A or row 1 for this.

[sheeeng]

Just selct column A or row 1 for this.

Can show some code example?

Thx! :friends:

[Bob Phillips]

Can show some code example?

Thx! :friends:



Sub Macro1()
'remove any previous freezing
ActiveWindow.FreezePanes = False
'Select the cell you want to start your freezing
'with no columns frozen
ActiveWorkbook.Sheets("Sheet1").Range("A5").Activate
'apply freezing
ActiveWindow.FreezePanes = True
End Sub

Sub Macro1()
'remove any previous freezing
ActiveWindow.FreezePanes = False
'Select the cell you want to start your freezing
'with no rows frozen
ActiveWorkbook.Sheets("Sheet1").Range("B1").Activate
'apply freezing
ActiveWindow.FreezePanes = True
End Sub

[sheeeng]

Sub Macro1()
'remove any previous freezing
ActiveWindow.FreezePanes = False
'Select the cell you want to start your freezing
'with no columns frozen
ActiveWorkbook.Sheets("Sheet1").Range("A5").Activate
'apply freezing
ActiveWindow.FreezePanes = True
End Sub

Sub Macro1()
'remove any previous freezing
ActiveWindow.FreezePanes = False
'Select the cell you want to start your freezing
'with no rows frozen
ActiveWorkbook.Sheets("Sheet1").Range("B1").Activate
'apply freezing
ActiveWindow.FreezePanes = True
End Sub


Thx. Initially I thought that there are no differnces btw above codes.
But after I run it, I realized that the FreezePane is much depended on location of the cell.

If the cell is uppermost part of the sheet, it will freeze pane vertically.
If the cell is leftmost part of the sheet, it will freeze pane horizonly.
Am I right of these two statements? :doh:

Thanks. :friends:

[Bob Phillips]

If the cell is uppermost part of the sheet, it will freeze pane vertically.
If the cell is leftmost part of the sheet, it will freeze pane horizonly.
Am I right of these two statements?


That's about right :)

[sheeeng]

Thank you, xld.
You are really a helping hand at this forum.

Thanks again.