Freeze Panes help

[Dan Wilson]

Good day. I am running Excel 2013 on Windows 10 Home. I have a workbook with 7 worksheets with several Macros. There is also a Macro in the "This Workbook" that runs every time the workbook is opened to set all the workbooks to a generic condition. Recently I discovered the need to use the Freeze Panes function to freeze Column 1 on 2 of the worksheets. All of the existing Macros use the same general formatting including freezing Row 1. How do I change the Macro in the 2 worksheets that require freezing Column 1 instead of Row 1? Any help is appreciated.
Thank you,
Dan Wilson...

 

[Dan Wilson]

Hi Fluff. I have no idea where that came from. I will try your suggestion. Each of the Macros was created individually and I don't recall doing anything to create a split screen. Oh well. I'll let you know.
Thanks, Dan...

 

[Dan Wilson]

OK, I tried your suggestion. Changing the "0" to a "1" makes the freezing of Row1 work fine. However, removing the "ActiveWindow.FreezePanes = True" removes the bottom bar allowing access to the other worksheets. Everything works well by not removing the freeze panes. I'm not sure why.
Thanks, Dan...

 

[Fluff]

Glad it's sorted & thanks for the feedback