ExcelBanter - How do you turn off "Row and Col headers" in Excel from VB macro?

ExcelBanter (https://www.excelbanter.com/)

- Excel Programming (https://www.excelbanter.com/excel-programming/)

- - How do you turn off "Row and Col headers" in Excel from VB macro? (https://www.excelbanter.com/excel-programming/343739-how-do-you-turn-off-row-col-headers-excel-vbulletin-macro.html)

gschultz

How do you turn off "Row and Col headers" in Excel from VB macro?

Can do it from menus but then when sheet is recreated the setting resets to on.
So what is the command/object to turn this off?

Norman Jones

How do you turn off "Row and Col headers" in Excel from VB macro?

Hi G,

Try:

ActiveWindow.DisplayHeadings = False

---
Regards,
Norman

"gschultz" wrote in message
...
Can do it from menus but then when sheet is recreated the setting resets
to on.
So what is the command/object to turn this off?

gschultz

How do you turn off "Row and Col headers" in Excel from VB mac

Funny - I saw and used the DisplayGuidlines but missed the DisplayHeaders.

Thanks Norman....

"Norman Jones" wrote:

Hi G,

Try:

ActiveWindow.DisplayHeadings = False

---
Regards,
Norman

"gschultz" wrote in message
...
Can do it from menus but then when sheet is recreated the setting resets
to on.
So what is the command/object to turn this off?

All times are GMT +1. The time now is 03:35 AM.