Freeze titles (Figer les volets)  
Author Message
DWedge





PostPosted: Mon Jun 19 21:57:47 CDT 2006 Top

Excel Programming >> Freeze titles (Figer les volets)

Hi everyone,
If I select A4 and freeze the titles, a line appears above line 4. Is it
possible to make this line disappear by code?
Thanks.
--
Jac Tremblay

Excel532  
 
 
Tom





PostPosted: Mon Jun 19 21:57:47 CDT 2006 Top

Excel Programming >> Freeze titles (Figer les volets) No, it isn't.

--
Regards,
Tom Ogilvy



> Hi everyone,
> If I select A4 and freeze the titles, a line appears above line 4. Is it
> possible to make this line disappear by code?
> Thanks.
> --
> Jac Tremblay


 
 
David





PostPosted: Mon Jun 19 22:07:34 CDT 2006 Top

Excel Programming >> Freeze titles (Figer les volets) Hi Jac,
That is part of Freeze Panes, you're stuck with it.
I don't find it a problem. Perhaps if you bolded your column and
row headings, you'd accept the lines as part of the headings.

You could choose a border at least as thick as the freeze lines..
Remember borders and interior color will override gridlines.
---
HTH,
David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001]
My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm
Search Page: http://www.mvps.org/dmcritchie/excel/search.htm


> Hi everyone,
> If I select A4 and freeze the titles, a line appears above line 4. Is it
> possible to make this line disappear by code?
> Thanks.
> --
> Jac Tremblay


 
 
jac





PostPosted: Tue Jun 20 21:02:01 CDT 2006 Top

Excel Programming >> Freeze titles (Figer les volets) Hi Tom,
That's what my coworkers and I thought. Just wanted to make sure.
Thanks for your answer. I appreciate.
--
Jac Tremblay




> No, it isn't.
>
> --
> Regards,
> Tom Ogilvy
>


> > Hi everyone,
> > If I select A4 and freeze the titles, a line appears above line 4. Is it
> > possible to make this line disappear by code?
> > Thanks.
> > --
> > Jac Tremblay
>
>
>
 
 
jac





PostPosted: Tue Jun 20 21:10:02 CDT 2006 Top

Excel Programming >> Freeze titles (Figer les volets) Hi David,
I do not find it a problem either myself, but the customers do and some
other developpers as well. Of course, we tried the borders, but the header
line extends beyond the current region which is sort of macramé looking. I
guess we will have to live with it. There are bigger problems in life
anyway...
Thanks for your answer. It is appreciated.
--
Jac Tremblay




> Hi Jac,
> That is part of Freeze Panes, you're stuck with it.
> I don't find it a problem. Perhaps if you bolded your column and
> row headings, you'd accept the lines as part of the headings.
>
> You could choose a border at least as thick as the freeze lines..
> Remember borders and interior color will override gridlines.
> ---
> HTH,
> David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001]
> My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm
> Search Page: http://www.mvps.org/dmcritchie/excel/search.htm
>

> > Hi everyone,
> > If I select A4 and freeze the titles, a line appears above line 4. Is it
> > possible to make this line disappear by code?
> > Thanks.
> > --
> > Jac Tremblay
>
>
>
 
 
David





PostPosted: Wed Jun 21 18:59:42 CDT 2006 Top

Excel Programming >> Freeze titles (Figer les volets) Hi Jac,

I don't think I would tell them right now, But at some time in the
future you could point out that when rows or columns are hidden
there is a thick border between the visible cells. Perhaps they
will then find out on their own the logical connection with how headers
in the repeated rows may be separated from the other rows/columns
shown in the screen at the moment. They again they might complain
that the bold line is there even if row 2 is also showing.
---
HTH,
David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001]
My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm
Search Page: http://www.mvps.org/dmcritchie/excel/search.htm


> Hi David,
> I do not find it a problem either myself, but the customers do and some


 
 
jac





PostPosted: Wed Jun 21 20:49:02 CDT 2006 Top

Excel Programming >> Freeze titles (Figer les volets) Thanks for your answer, David.
By the way, I checked your site and found a lot of interesting topics. That
will keep me busy for hours.
--
Jac Tremblay




> Hi Jac,
>
> I don't think I would tell them right now, But at some time in the
> future you could point out that when rows or columns are hidden
> there is a thick border between the visible cells. Perhaps they
> will then find out on their own the logical connection with how headers
> in the repeated rows may be separated from the other rows/columns
> shown in the screen at the moment. They again they might complain
> that the bold line is there even if row 2 is also showing.
> ---
> HTH,
> David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001]
> My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm
> Search Page: http://www.mvps.org/dmcritchie/excel/search.htm
>

> > Hi David,
> > I do not find it a problem either myself, but the customers do and some
>
>
>