Thread: Freeze pane of all Sheets how?
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Eddy[_6_] Eddy[_6_] is offline
external usenet poster
  
Posts: 4
Default 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/



Reply With QuoteReply With Quote