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

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 *

"Hotbird" wrote in message
...
Can someone tell me how to switch Row and Coumn headers on and off in VBA?

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

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



.

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 :)


---
Message posted from http://www.ExcelForum.com/

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!!!

"JerryG" wrote in message
...

ActiveWindow.DisplayHeadings = False
ActiveWindow.DisplayHeadings = True

Hope this was what you were looking for.


JerryG :)