View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.programming
Craig[_8_] Craig[_8_] is offline
external usenet poster
 
Posts: 18
Default 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.

.

.

.

.