| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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? |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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? |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Turn off "CALCULATE" on bottom of Excel worksheet. near "Ready" | Excel Discussion (Misc queries) | |||
| Disabling the "&[Time]" or "&[T]" in Excel headers and footers | Excel Discussion (Misc queries) | |||
| Excel - Golf - how to display "-2" as "2 Under" or "4"as "+4" or "4 Over" in a calculation cell | Excel Discussion (Misc queries) | |||
| "Turn "record macro" display on. | Excel Discussion (Misc queries) | |||
| Macro to turn on "Track Changes" function | Excel Discussion (Misc queries) | |||
Linear Mode
