Freeze Panes

[KULRANJANSINGH1]

I want to create a page in the ms excel vbo to create freeze panes i have recorded a macro and the code for it is

With ActiveWindow
.SplitColumn = 0
.SplitRow = 1
End With
ActiveWindow.FreezePanes = True


The issue is use of ActiveWindow as it can't be use like ActiveWorkbook or ActiveWorksheet, Is there any way we can ActivateWindow

------------------------------
KULRANJAN SINGH NEGI
Associate Professional Programmer Analyst
DXC Technology
Asia/Kolkata
------------------------------

[John__Carter]

You could adjust the code so it works on a specific window, rather than the active one.

------------------------------
John Carter
Professional Services
Blue Prism
------------------------------