Qn: Column/Row Hide??

  • Thread starter Michael Vaughan
  • Start date
M

Michael Vaughan

Hello Everyone,

Is there a way to hide the labels A,B,C.... 1,2,3.... and so on. Is there a
command such as:

Application.CommandBars("Standard").Visible = False

I don't want to hide a whole row or column, I just want to hide the labels
that say A,B, C, 1,2,3.. and so on, and keep all the cells. Kind of clean
up the screen if you know what I mean??? I want to hide all the menu bars
and labels so my program has a clean fresh look.

Thanks.. mv
 
D

Dave Peterson

Record a macro when you do:

tools|options|view tab
and uncheck Row and column headers.

I got this line:

ActiveWindow.DisplayHeadings = False
 
Top