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

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

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 ***

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 ***

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