View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
japorms[_3_] japorms[_3_] is offline
external usenet poster
 
Posts: 1
Default 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/