https://community.blueprism.com/t5/Product-Forum/Freeze-Panes/m-p/52937#M7733 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<BR /><BR /> With ActiveWindow<BR /> .SplitColumn = 0<BR /> .SplitRow = 1<BR /> End With<BR /> ActiveWindow.FreezePanes = True<BR /><BR /><BR />The issue is use of ActiveWindow as it can't be use like ActiveWorkbook or ActiveWorksheet, Is there any way we can ActivateWindow<BR /><BR />------------------------------<BR />KULRANJAN SINGH NEGI<BR />Associate Professional Programmer Analyst<BR />DXC Technology<BR />Asia/Kolkata<BR />------------------------------<BR /> Thu, 29 Aug 2019 10:17:00 GMT KULRANJANSINGH1 2019-08-29T10:17:00Z https://community.blueprism.com/t5/Product-Forum/Freeze-Panes/m-p/52937#M7733 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<BR /><BR /> With ActiveWindow<BR /> .SplitColumn = 0<BR /> .SplitRow = 1<BR /> End With<BR /> ActiveWindow.FreezePanes = True<BR /><BR /><BR />The issue is use of ActiveWindow as it can't be use like ActiveWorkbook or ActiveWorksheet, Is there any way we can ActivateWindow<BR /><BR />------------------------------<BR />KULRANJAN SINGH NEGI<BR />Associate Professional Programmer Analyst<BR />DXC Technology<BR />Asia/Kolkata<BR />------------------------------<BR /> Thu, 29 Aug 2019 10:17:00 GMT https://community.blueprism.com/t5/Product-Forum/Freeze-Panes/m-p/52937#M7733 KULRANJANSINGH1 2019-08-29T10:17:00Z https://community.blueprism.com/t5/Product-Forum/Freeze-Panes/m-p/52938#M7734 You could adjust the code so it works on a specific window, rather than the active one.<BR /><BR />------------------------------<BR />John Carter<BR />Professional Services<BR />Blue Prism<BR />------------------------------<BR /> Fri, 30 Aug 2019 07:55:00 GMT https://community.blueprism.com/t5/Product-Forum/Freeze-Panes/m-p/52938#M7734 John__Carter 2019-08-30T07:55:00Z