Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Qn: Column/Row Hide??
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Qn: Column/Row Hide??
Record a macro when you do:
tools|options|view tab and uncheck Row and column headers. I got this line: ActiveWindow.DisplayHeadings = False Michael Vaughan wrote: 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 -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Hide Column | Excel Discussion (Misc queries) | |||
Hide Column If Usedrange of Column ISBLANK Follow-up | Excel Discussion (Misc queries) | |||
Hide Column If Usedrange of Column ISBLANK | Excel Discussion (Misc queries) | |||
Hide column or row based on a cell in the column or row? | Excel Discussion (Misc queries) | |||
hide column | New Users to Excel |