Qn: Column/Row Hide??

  • Thread starter Thread starter Michael Vaughan
  • Start date 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
 
Record a macro when you do:

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

I got this line:

ActiveWindow.DisplayHeadings = False
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Hide / Unhide each row from StartRow to LastRow for multiple conditions 6
hiding blank rows 3
How do you hide ..... 2
hiding the column and row designators 3
Multiple SUM's in a column 15
Macro to hide colums with value of zero or blank 3
Speeding up Hide rows code 2
peculiar condition: form optionbuttons lose position and linkedcellon row hide 1

Back
Top