Hide names of columns and rows by code.
 

Hello,

I was wondering if there is some sort of command to hide the ABCDE and
12345etc...

Robert

Hide names of columns and rows by code.
 

Sub CanYouSeeThem()
If TypeName(Selection) = "Range" Then
ActiveWindow.DisplayHeadings = Not ActiveWindow.DisplayHeadings
End If
End Sub
--
Jim Cone
San Francisco, USA
http://www.realezsites.com/bus/primitivesoftware



"Robert"
wrote in message
Hello,
I was wondering if there is some sort of command to hide the ABCDE and
12345etc...
Robert

Hide names of columns and rows by code.
 

Thanks a lot. Works perfect.

Ronert


On 24 jun, 20:08, "Jim Cone" wrote:
Sub CanYouSeeThem()
If TypeName(Selection) = "Range" Then
ActiveWindow.DisplayHeadings = Not ActiveWindow.DisplayHeadings
End If
End Sub
--
Jim Cone
San Francisco, USAhttp://www.realezsites.com/bus/primitivesoftware

"Robert"
wrote in message
Hello,
I was wondering if there is some sort of command to hide the ABCDE and
12345etc...
Robert

Hide names of columns and rows by code.
 

ActiveWindow.DisplayHeadings = False 'Off
ActiveWindow.DisplayHeadings = True 'On


"Robert" wrote:

Hello,

I was wondering if there is some sort of command to hide the ABCDE and
12345etc...

Robert