Freeze pane of all Sheets how?

J

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?
 
E

Eddy

Try this one

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