- Feb 5, 2006
- Office Version
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.