| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Custom Header Aligment
Dear Experts,
I am using different fonts in the left and right customer header, both align to the top but I would like both stick to the bottom .. something like ActiveSheet.PageSetup.RightHeader.Alignment = xlBottom but this doen't work. Tks |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Custom Header Aligment
On 6 mrt, 13:11, Seeker wrote:
Dear Experts, I am using different fonts in the left and right customer header, both align to the top but I would like both stick to the bottom .. something like ActiveSheet.PageSetup.RightHeader.Alignment = xlBottom but this doen't work. Tks Hi Seeker, As far as I know it is not possible to align the headers. You can use a trick the simulate it. Suppose you have a 14 point text in the left header and a 8 point text in the right header. Just put a 8 point line with only a space character above the line in the left header. And put a 14 poit line with only a space character above the in the right header HTH, Wouter |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Custom Header Aligment
Hi Wouter,
Thanks for your help, the tricks works. Rgds "Wouter HM" wrote: On 6 mrt, 13:11, Seeker wrote: Dear Experts, I am using different fonts in the left and right customer header, both align to the top but I would like both stick to the bottom .. something like ActiveSheet.PageSetup.RightHeader.Alignment = xlBottom but this doen't work. Tks Hi Seeker, As far as I know it is not possible to align the headers. You can use a trick the simulate it. Suppose you have a 14 point text in the left header and a 8 point text in the right header. Just put a 8 point line with only a space character above the line in the left header. And put a 14 poit line with only a space character above the in the right header HTH, Wouter . |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Aligment of DropDownList | Excel Programming | |||
| Aligment of DropDownList | Excel Programming | |||
| Can you link a custom property to an Excel custom header text? | Setting up and Configuration of Excel | |||
| Excel: custom header - is it possible to paste into header? | Excel Worksheet Functions | |||
| how do I permanetly add custom header to excel header list? | Excel Discussion (Misc queries) | |||
Linear Mode
