H
Hotbird
Can someone tell me how to switch Row and Coumn headers on and off in VBA?
A
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 *
ActiveWindow.DisplayHeadings = Not ActiveWindow.DisplayHeadings
End Sub
--
Regards,
Auk Ales
* Please reply to this newsgroup only *
* I will not react on unsolicited e-mails *
P
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
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
J
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
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
H
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!!!
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!!!