Formats many sheets
Ok!!! :-)
What do I put at the start of the Macro??
Dim sh as Worksheet
For each sh in Worksheets
..
..
..
Next
???
(I'm a bit of a novice at this - can you tell??)
-----Original Message-----
Hi
simply record a macro while doing this manually :-)
-----Original Message-----
Frank,
This is OK, but for just about every workbook that I
use,
I apply the below-mentioned properties.
Can someone supply me with the VBA way???
Thanks,
Craig.
-----Original Message-----
Hi
a non VBA way:
- first group all the required sheets (hold down the
SHIFT
key and select the sheets with your mouse)
- apply your formating
-----Original Message-----
Hi,
Is there a way I can do the following for all sheets
in
a
workbook (i.e. using a Macro), without having to
manually
do it for each one??
Center the sheet horizontally and vertically (for
Printout);
Include Row and Column Headings (for Printout);
Fit each sheet to 1 page wide by 1 page tall (for
Printout)
Makes each sheet Landscape (for Printout);
Makes the left and right margins 0.9 inches each (for
Printout);
Adjust zoom size for each sheet to 85%;
Remove gridlines from each sheet;
Include a header in each sheet, on the left, that has
the
tab name of the sheet in Arial, 14 point, bold.
Many Thanks,
Craig.
.
.
.
.
|