Prev: Data Entry to a Cell Range
Next: -->edit -->clear -->all; Can removed from standard menu?
From: Seeker on 6 Mar 2010 07:11
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
From: Wouter HM on 6 Mar 2010 08:17
On 6 mrt, 13:11, Seeker <See...(a)discussions.microsoft.com> 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
From: Seeker on 6 Mar 2010 17:19
Hi Wouter,
Thanks for your help, the tricks works.
Rgds

"Wouter HM" wrote:

> On 6 mrt, 13:11, Seeker <See...(a)discussions.microsoft.com> 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
> .
>
 | 
Pages: 1
Prev: Data Entry to a Cell Range
Next: -->edit -->clear -->all; Can removed from standard menu?