| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.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 |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Freeze titles (Figer les volets)
No, it isn't.
-- Regards, Tom Ogilvy "Jac Tremblay" wrote in message ... 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 |
|
#3
Posted to microsoft.public.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 "Jac Tremblay" wrote in message ... 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 |
|
#4
Posted to microsoft.public.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 "Tom Ogilvy" wrote: No, it isn't. -- Regards, Tom Ogilvy "Jac Tremblay" wrote in message ... 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 |
|
#5
Posted to microsoft.public.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 "David McRitchie" wrote: 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 "Jac Tremblay" wrote in message ... 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 |
|
#6
Posted to microsoft.public.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 "Jac Tremblay" wrotem... Hi David, I do not find it a problem either myself, but the customers do and some |
|
#7
Posted to microsoft.public.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 "David McRitchie" wrote: 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 "Jac Tremblay" wrotem... Hi David, I do not find it a problem either myself, but the customers do and some |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Excel 2003 freeze panes won't freeze top row only | Excel Discussion (Misc queries) | |||
| freeze pane: freeze from two worksheets? | Excel Discussion (Misc queries) | |||
| Y Axis Titles (Excel is clipping titles) | Excel Discussion (Misc queries) | |||
| Titles | Excel Discussion (Misc queries) | |||
| Id like to freeze the first row for headers and freeze the very b. | Charts and Charting in Excel | |||
![Jac Tremblay[_4_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Linear Mode
