Thread: Hide names of columns and rows by code.
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Jim Cone Jim Cone is offline
external usenet poster
  
Posts: 3,290
Default 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

Reply With QuoteReply With Quote