Recording page set-up macro
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 . |
All times are GMT +1. The time now is 12:58 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com