hi,
i have a macro with the following code:
With ActiveSheet.PageSetup
.LeftHeader = "&D"
the macro is ok in 2003, when i try to run it in 2007 i got the following
message:
"unable to set the Left header property of the PageSetup class"
could you please advice, i need the code to work in both environments.
thanks,
--
Miri Tz.

this works in both versions for me
With ws3.PageSetup
.LeftHeader = "&G"
end with

which shows a picture
and

..LeftHeader = "&D"
shows the date in both versions for me, too.

post the code

--


Gary

"Miri" <(E-Mail Removed)> wrote in message
news:5EA9A4C9-DCA4-460C-8591-(E-Mail Removed)...
> hi,
> i have a macro with the following code:
> With ActiveSheet.PageSetup
> .LeftHeader = "&D"
> the macro is ok in 2003, when i try to run it in 2007 i got the following
> message:
> "unable to set the Left header property of the PageSetup class"
> could you please advice, i need the code to work in both environments.
> thanks,
> --
> Miri Tz.

maybe the code is ok, but in my 2007 i miss the dll or any other
configuration. please advice ...which dll i should look for...
--
Miri Tz.


"Gary Keramidas" wrote:

> this works in both versions for me
> With ws3.PageSetup
> .LeftHeader = "&G"
> end with
>
> which shows a picture
> and
>
> ..LeftHeader = "&D"
> shows the date in both versions for me, too.
>
> post the code
>
> --
>
>
> Gary
>
> "Miri" <(E-Mail Removed)> wrote in message
> news:5EA9A4C9-DCA4-460C-8591-(E-Mail Removed)...
> > hi,
> > i have a macro with the following code:
> > With ActiveSheet.PageSetup
> > .LeftHeader = "&D"
> > the macro is ok in 2003, when i try to run it in 2007 i got the following
> > message:
> > "unable to set the Left header property of the PageSetup class"
> > could you please advice, i need the code to work in both environments.
> > thanks,
> > --
> > Miri Tz.
>
>