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?