Freeze pane of all Sheets how?

[japorms]

Hello !

Can anybody please help me

I need to freeze row F3 of all the sheets in my excel file

Currently I make this code

Range("F3").Select
Excel.Windows(1).FreezePanes = True


but that code only freezes the current sheet or window

I need all the sheet to be freeze

anybody know how?

 

[Eddy]

Try this one

Dim wkt As Worksheet
For Each wkt In ThisWorkbook.Worksheets
wkt.Activate
Range("F3").Select
ActiveWindow.FreezePanes = True
Next