Freeze pane in non-active sheet

[airbatucampur92]

i want to freeze pane in sheet 2 without need to activate it since sheet 1 is active sheet. all the code that i found using ActiveWindow
like code in below. is there any way to freeze pane without activate it?

Please Login or Register  to view this content.

[ARGK]

Hi
Why do you want to freeze a pane on an inactive sheet? What is the purpose?
Tony