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 major issue is use of ActiveWindow as it can't be use like ActiveWorkbook or...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.