Scaling for multiple sheets

Joe1 · #1 (**permalink**) 09-17-07, 09:56

My excel doc has about 200 sheets. I’m 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

shades · #2 (**permalink**) 09-17-07, 10:25

Howdy. You could use a For Each statement and loop through all worksheets. This avoids selecting the worksheets, also.

pierrevbaexcel · #3 (**permalink**) 09-18-07, 20:22

Joe1

Are you looking for a VBA way

Internet Services

Web Development

Digital Marketing

Consumer Tech