Remove Row/Column Headers

[Guest]

How do I remove the "row & column headers" in vba? I tried versions of;
Application.DisplayHeadersBar = False. but can't get the code to remove
headers.

Any help is always appreciated.
Thanks

 

[Bob Phillips]

ActiveWindow.DisplayHeadings = False

--

HTH

RP
(remove nothere from the email address if mailing direct)

 

[Guest]

Is it possible to remove DisplayHeadings from all Worksheets in a Workbook?
Using ActiveWindow.DisplayHeadings = False works great for a worksheet but I
would like to have something like
"Application.CommandBars("DisplayHeadings").Visible = False" or
"Application.DisplayHeadings = False" that would be global for the Workbook.

Currently, the I am putting the "ActiveWindow.DisplayHeadings = False" on
each Worksheet_Activate event, which works in a round about way.

Any help is always appreciated.

Regards