2003-2007"unable to set the Left header property of the PageSetup
 

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.

2003-2007"unable to set the Left header property of the PageSetup
 

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" wrote in message
...
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.

2003-2007"unable to set the Left header property of the PageS
 

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" wrote in message
...
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.