Tools/Options/ Row & column headers

[Hotbird]

Can someone tell me how to switch Row and Coumn headers on and off in VBA?

 

[A.W.J. Ales]

Sub ToggleRowHeaders()
ActiveWindow.DisplayHeadings = Not ActiveWindow.DisplayHeadings
End Sub

--
Regards,
Auk Ales

* Please reply to this newsgroup only *
* I will not react on unsolicited e-mails *

 

[Patrick Molloy]

Start the macro recorder. turn the headers off. stop
recording. start recording. turn them on & stop
recording. Now examine the resulting code.

Sub TurnHeaders_OFF()
ActiveWindow.DisplayHeadings = False
End Sub
Sub TurnHeaders_ON()
ActiveWindow.DisplayHeadings = True
End Sub


Patrick Molloy
Microsoft Excel MVP

 

[JerryG]

This turns off the display of row and column headings in the active
window:

ActiveWindow.DisplayHeadings = False


This turns the row and column headings back on:

ActiveWindow.DisplayHeadings = True



Hope this was what you were looking for.


JerryG

 

[Hotbird]

Yes, it was exactly what I was looking for, Jerry, many thanks.

TY also to the other poster who suggested that the Macro recorder was an
easy way to find the correct code. I had spent quite long enough on a
fruitless search through F1 Help, and must admit I forgot the obvious!!!