Re: Possible to hide column headers???

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance



Hi Tempy,

You show how to hide rows or columns.

I believe that T-®ex wants to hide the headers only.

---
Regards,
Norman



"Tempy" <anonymous@xxxxxxxxxx> wrote in message
news:ercdJE6rFHA.1028@xxxxxxxxxxxxxxxxxxxxxxx
> 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 ***


.



Relevant Pages

  • Re: Help with Macro
    ... >From the Intermediate window: ... Regards, ... Norman ... Prev by Date: ...
    (microsoft.public.excel.programming)
  • Re: Define Range in VBA
    ... Regards, ... Norman ... > I have the limits of a range as 2 columns (the first one, it;s fixed, ... Prev by Date: ...
    (microsoft.public.excel.programming)
  • Re: Sort a numeric field
    ... I cannot speak English so: Dank u! ... Regards, ... Norman ... Prev by Date: ...
    (microsoft.public.excel.misc)
  • Re: checking for a blank field
    ... In older versions of Excel, you may have to Save, then ... >>> Regards, ... >>> Norman ... Prev by Date: ...
    (microsoft.public.excel.programming)
  • Re: Like Function
    ... Regards, ... Norman ... > at the begining of it name plus the other name sheets ... Prev by Date: ...
    (microsoft.public.excel.programming)