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
-----Original Message-----
Hi
what were you trying to change in the page setup dialog?

--
Regards
Frank Kabel
Frankfurt, Germany


Shawnae wrote:
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
.