Hi Excel Experts,
I have recorded a macro where I select 3 worksheets in a workbook by clicking on the first one and shift-clicking on the last one to select all three sheets. I then go into the page setup and set my various settings, landscape, fit to 1 page tall, fit to 1 page wide, footers, etc. However, when I run the macro, none of the settings take even though I am getting no error messages. I made sure my zoom setting was set to false so that the fit to 1 page tall/wide would take but still no positive effect. Will I have to select each sheet individually and configure the page/print settings or am I missing something else ??
Thanks,
Joe Dowski
Woodbury, CT. USA.
I have recorded a macro where I select 3 worksheets in a workbook by clicking on the first one and shift-clicking on the last one to select all three sheets. I then go into the page setup and set my various settings, landscape, fit to 1 page tall, fit to 1 page wide, footers, etc. However, when I run the macro, none of the settings take even though I am getting no error messages. I made sure my zoom setting was set to false so that the fit to 1 page tall/wide would take but still no positive effect. Will I have to select each sheet individually and configure the page/print settings or am I missing something else ??
Thanks,
Joe Dowski
Woodbury, CT. USA.