Freeze Panes without using select

[dagindi]

So I recently learned that I cannot use select when working with a macro that loops through multiple sheets in a workbook.

I cannot figure out the correct way to code the macro so that i can use freeze pane on A2 for all the sheets.

I would like it to go at the end of this part of the code:

Please Login or Register  to view this content.

[mrice]

It's a bit inelegant but this should work.

Please Login or Register  to view this content.

[TMS]

Perhaps a slight enhancement ...

Please Login or Register  to view this content.

Regards