Results 1 to 3 of 3
  1. #1
    Join Date
    Nov 2004
    Posts
    78

    Unanswered: Scaling for multiple sheets

    My excel doc has about 200 sheets. Im trying to change the Scaling for all sheets at once (Adjust to_ _ % of normal size).
    I have selected all sheets. However, only the fist sheet is changed.

    How can I fix this?
    Thanks

    Excel 2002

  2. #2
    Join Date
    Oct 2003
    Posts
    1,091
    Howdy. You could use a For Each statement and loop through all worksheets. This avoids selecting the worksheets, also.
    old, slow, and confused
    but at least I'm inconsistent!

    Rich
    (retired Excel 2003 user, 3/28/2008)

    How to ask a question on forums

  3. #3
    Join Date
    Dec 2003
    Location
    Ottawa, Canada
    Posts
    72
    Joe1

    Are you looking for a VBA way
    A piece of data is like a brick
    If you don't build anything with it
    It is just a brick
    www.excel-examples.com

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •