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
.SplitColumn = 0
.SplitRow = 1
ActiveWindow.FreezePanes = True
The major issue is use of ActiveWindow as it can't be use like ActiveWorkbook or...