asked on

Hide freeze pane lines in excel 2013

Does any one have a method for hiding or formatting freeze pane lines on excel spreadsheets please?

ASKER CERTIFIED SOLUTION

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Here is a place to start if you're going that route. It's only the beginning step of some deep looking into it unless someone else here knows.

https://social.msdn.microsoft.com/Forums/en-US/ca0c5112-63ee-4104-adb2-2eccc3b9faed/freeze-pane-in-vsto2005?forum=vsto

I guess the first question is, are you willing to code or do you expect it in the menus of Excel somewhere?

anyway here is the pane property discussed at MSDN

https://msdn.microsoft.com/en-us/library/office/microsoft.office.interop.excel.window.panes.aspx

and if you go to the bottom of that and click on the Window members it says gridlines, but don't know if that includes freeze pane lines, are part of the window as you can see here.

https://msdn.microsoft.com/en-us/library/office/microsoft.office.interop.excel.window_members.aspx

I don't know how to go further here, but probably someone else at EE does know if you're going to try.

ASKER

Thank you for your comments, I thought that was the case but thought I would check with greater minds than mine.

Goodness gracious!! You better leave the question open for someone else then. :) thank you for the points.