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

M

Miri

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,
 
G

Gary Keramidas

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
 
M

Miri

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...
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top