Is there any way to save a workbook as an html file and retain the freeze panes functionality? My current workbook has the column headings frozen and has several hundred rows of data. I need to be able to save as an html, but the column headings are no longer frozen. Can it be done in VBA?

Thanks in advance for any help anyone can provide!

Scott