Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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/ |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
FREEZE PANE | Excel Discussion (Misc queries) | |||
freeze pane | Excel Discussion (Misc queries) | |||
freeze pane: freeze from two worksheets? | Excel Discussion (Misc queries) | |||
Freeze pane | Excel Discussion (Misc queries) | |||
Freeze pane | Excel Worksheet Functions |