Reputation: 22334
I'm building a Visual Studio workbook add-in component for Excel (2007+). I have a few worksheets in my VSTO-modified workbook that I want to disable the Headings in code. (what you can do in the Excel ribbon > View > Headings 'checkbox'). Does anyone know how to do this?
Upvotes: 3
Views: 202
Reputation: 149287
VB.Net
Me.Application.ActiveWindow.DisplayHeadings = False
C #
this.Application.ActiveWindow.DisplayHeadings = false;
Upvotes: 3