Group All Sheets in a workbook

[Michael Smith]

Anyone know the code to group all Sheets in a workbook??...trying to do
the same page setup on all sheets in a workbook and need to group them
together first.

TIA.
-mike


*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!

 

[PaulD]

: Anyone know the code to group all Sheets in a workbook??...trying to do
: the same page setup on all sheets in a workbook and need to group them
: together first.
:
: TIA.
: -mike

Well, not sure exactly what you mean but there are several ways to select
worksheets.

You can use the sheets collection
Sheets.Select
to select all sheets

or you can iterate throught the collection
for each sh in sheets
...code here
next sh

you could array the sheets
Sheets(Array("Sheet1", "Sheet2", "Sheet3", "Sheet4")).Select

I believe .pagesetup is a propert of worksheet only so you either need to
group them first then use activesheet or iterate
Paul