freezpane set macro

[kalpeshpatel]

how to set freezpane in sheet1 for column m2 with macro only

 

[NARAYANK991]

Hi Kalpesh ,


Put the following code in the ThisWorkBook section of your VBA Project :

[pre]

Public Sub freeze_panes()
Worksheets("Sheet1").Activate    ' Change this to whatever you want
ActiveWindow.Split = False
Range("M3").Select               ' Change this to whatever you want
ActiveWindow.FreezePanes = True
End Sub

[/pre]

Narayan