Okay, I will have a word with myself and see if I can get one <vbg

Bob

"Excel'ed Failures" wrote in
message ...
Bob, as always thank you. You really saved my bacon! This job would have
taken me all morning and to do and now I am finished. I love the, "How
are
you already finished!" reaction I got. Where ever you work Mr. Phillips
you
need a raise!

"Bob Phillips" wrote:

For Each sh In Activeworkbook.Worksheets
... your code
Next sh

and in you code change Activesheet to sh.

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)

"Excel'ed Failures" wrote in
message ...
Hello everyone, thank you for all your help! You guys are wonderful.
I
have
a new challange that I am faced with, a rather tedious one at that. I
have a
workbook that has 50+ worksheets. I need to change the print margins
to 0
as
well as the page orientation to portrait on every page. I can't
program
VBE
but I recorded a macro that does what I need it to. I deleted all the
stuff
I didn't need and it works. However it only works on the worksheet
that
is
open. What code do I add to make it cycle through every worksheet? I
don't
know how to program in VBE so please keep it simple. Thank you for
your
help
in advance... I owe you guys a beer.