Recording page set-up macro

S

Shawnae

I am recording macros in Excel 2002 and all but one is
working fine. I tried to record the page set up. It
allows me to go through the motions of recording, but
when I run the macro it doesn't work. I found out
through selecting the Edit function, there is nothing in
the codes. Could it be that its not possible to do in
Excel 2002; although, it worked well for me in Excel 97?

Thanks
 
S

Shawnae

I want a macro to run Page setup. I want it to change
from portrait to landscape, add a footer and change the
margins.

I'm trying to automate a report, that is run daily, for a
group of people who are basically illiterate when it
comes to any software.

Thanks
 
Top