How to freeze pane?

For example, I click cell F4, then freeze the sheet to make top 3 rows and left 5 columns visible.

How to do it with VBA?

Edit: By the way, I have For Each WS in WB.Worksheets loop, I want to do it for each worksheet.

Please Login or Register  to view this content.

By the way, I have For Each WS in WB.Worksheets loop, how to change ActiveWindow with WS. I forgot to mention that I want to do it for each worksheet.

Please Login or Register  to view this content.

@VAer

Administrative Note re. Forum Guideline #2:

Please don't quote whole posts, especially when you are responding to the one immediately preceding your own - it's just clutter and rarely necessary.

If you are responding out of sequence, it is usually enough just to mention the helper's user name (e.g @AliGW).

If you do need to quote, limit the quoted section just to the section to which you wish to draw your helper's attention or a direct question to which you wish to respond.

For normal conversational replies, try using the QUICK REPLY box below or the REPLY button instead of REPLY WITH QUOTE.

You're welcome and thanks for rep+.