page setup
 

I am trying to use page setup for all the sheets in a workbook by selecting
all sheets and then going to page setup but the feature is 'grayed out'.

The freeze pane feature also does not work when I choose all sheets in the
work book.

Any Suggestions?

page setup
 

No can do, must be done specifically for each sheet. Even in a macro, you
have to loop through the sheeets one by one (For Each ws in myBook)...
--
Please remember to indicate when the post is answered so others can benefit
from it later.


"JJ@ARC" wrote:

I am trying to use page setup for all the sheets in a workbook by selecting
all sheets and then going to page setup but the feature is 'grayed out'.

The freeze pane feature also does not work when I choose all sheets in the
work book.

Any Suggestions?

page setup
 

After selecting all sheets do not try to use page setup when in Print
Preview mode.

Regular page setup mode will allow multiple sheets to be setup.


Gord Dibben MS Excel MVP


On Thu, 23 Jul 2009 07:21:03 -0700, JJ@ARC
wrote:

I am trying to use page setup for all the sheets in a workbook by selecting
all sheets and then going to page setup but the feature is 'grayed out'.

The freeze pane feature also does not work when I choose all sheets in the
work book.

Any Suggestions?

page setup
 

Not true.

Page setup can be done on multiple selected sheets without a macro.


Gord Dibben MS Excel MVP

On Thu, 23 Jul 2009 13:25:01 -0700, KC hotmail com <kcrippstein<atdot
wrote:

No can do, must be done specifically for each sheet. Even in a macro, you
have to loop through the sheeets one by one (For Each ws in myBook)...