Hello,
I have problem with freezing/unfreezing panes in a specific workbook in excel 2013, windows 10.
The workbook and worksheets are protected and contain VBA code.
I can freeze and unfreeze panes in excel 2010 windows 7, after unprotecting the workbook. In 2013 button to freeze panes in view tab is greyed out after unprotecting and I can't click on it.
I tried using different view settings, normal, page break and page layout but it doesn’t work.
I also tried using VBA code to freeze panes but I receive an error “unable to set the freeze panes property of the Windows class”.
Any idea how I could make it running in excel 2013 win 10?
Thank you
I have problem with freezing/unfreezing panes in a specific workbook in excel 2013, windows 10.
The workbook and worksheets are protected and contain VBA code.
I can freeze and unfreeze panes in excel 2010 windows 7, after unprotecting the workbook. In 2013 button to freeze panes in view tab is greyed out after unprotecting and I can't click on it.
I tried using different view settings, normal, page break and page layout but it doesn’t work.
I also tried using VBA code to freeze panes but I receive an error “unable to set the freeze panes property of the Windows class”.
Any idea how I could make it running in excel 2013 win 10?
Thank you