Remove Row/Column Headers
 

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

Remove Row/Column Headers
 

ActiveWindow.DisplayHeadings = False

--

HTH

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


"Ronbo" wrote in message
...
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

Remove Row/Column Headers
 

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").Visibl e = 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


"Bob Phillips" wrote:

ActiveWindow.DisplayHeadings = False

--

HTH

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


"Ronbo" wrote in message
...
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