Freeze pane of all Sheets how?
 

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?


---
Message posted from http://www.ExcelForum.com/

Freeze pane of all Sheets how?
 

Try this one

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

"japorms " ¼¶¼g©ó¶l¥ó
...
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?


---
Message posted from http://www.ExcelForum.com/