Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Possible to hide column headers???
Hi! I'd like to know if it's possible to hide the column (and row) "headers" in Excel... If it is, how do I do it? -- T-®ex ------------------------------------------------------------------------ T-®ex's Profile: http://www.excelforum.com/member.php...o&userid=26572 View this thread: http://www.excelforum.com/showthread...hreadid=401401 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Possible to hide column headers???
Hi T-®ex,
Tools | Options | View | deselect 'Row & Column headers' If you need to do this programmatically, try something like: ActiveWindow.DisplayHeadings = False --- Regards, Norman "T-®ex" wrote in message ... Hi! I'd like to know if it's possible to hide the column (and row) "headers" in Excel... If it is, how do I do it? -- T-®ex ------------------------------------------------------------------------ T-®ex's Profile: http://www.excelforum.com/member.php...o&userid=26572 View this thread: http://www.excelforum.com/showthread...hreadid=401401 |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Possible to hide column headers???
Hi T-®ex,
I used the code below Range("Headers").EntireRow.Hidden = True - For a Named range Rows("1:1").EntireRow.Hidden = True Columns("A:A").EntireColumn.Hidden = True Tempy *** Sent via Developersdex http://www.developersdex.com *** |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Possible to hide column headers???
Hi Tempy,
You show how to hide rows or columns. I believe that T-®ex wants to hide the headers only. --- Regards, Norman "Tempy" wrote in message ... Hi T-®ex, I used the code below Range("Headers").EntireRow.Hidden = True - For a Named range Rows("1:1").EntireRow.Hidden = True Columns("A:A").EntireColumn.Hidden = True Tempy *** Sent via Developersdex http://www.developersdex.com *** |
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
Possible to hide column headers???
Thanks, Norman Jones!!! :) Norman Jones Wrote: Hi T-®ex, Tools | Options | View | deselect 'Row & Column headers' If you need to do this programmatically, try something like: ActiveWindow.DisplayHeadings = False --- Regards, Norman "T-®ex" wrote in message ... Hi! I'd like to know if it's possible to hide the column (and row) "headers" in Excel... If it is, how do I do it? -- T-®ex ------------------------------------------------------------------------ T-®ex's Profile: http://www.excelforum.com/member.php...o&userid=26572 View this thread: http://www.excelforum.com/showthread...hreadid=401401 -- T-®ex ------------------------------------------------------------------------ T-®ex's Profile: http://www.excelforum.com/member.php...o&userid=26572 View this thread: http://www.excelforum.com/showthread...hreadid=401401 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Hide or Protect Headers | Excel Discussion (Misc queries) | |||
How to Hide Row & Column Headers in Excel ? | Excel Discussion (Misc queries) | |||
How do I hide the column and row default headers in Excel? | Excel Discussion (Misc queries) | |||
Show/Hide Column and Row Headers | Excel Discussion (Misc queries) | |||
How to hide/show row/column headers and sheet tabs. | Excel Programming |