Macro

[ebruewer]

Hi All,

I am trying to write a macro that will do the following on all sheets within a workbook:

Print layout: Orientation
Fit to one page
print titles: 1:1

 

[James006]

Hi,

A quick and simple solution consists of ... turning on your macro recorder
and going through your process for one worksheet ...
You will get a "VBA translation of your actions"
Then adding a loop for your sheets will be extremely easy ...

Hope this will help