Adjust Zoom for Sheets

**erock24** · 01-19-2008, 06:43 PM

I need a macro to cycle through my desired sheets and set the zoom to 75%.

My desired sheets are:

Please Login or Register  to view this content.

I have tried using what the recorder popped out but could not get anything to work. Any Ideas??

**VBA Noob** · 01-19-2008, 06:59 PM

One Way

Please Login or Register  to view this content.

or

Please Login or Register  to view this content.

or just right click the sheet names > select view code and add the below

Please Login or Register  to view this content.

VBA Noob

**royUK** · 01-20-2008, 03:39 AM

Alternatively, use this to avoid having to activate each sheet

Please Login or Register  to view this content.

**VBA Noob** · 01-20-2008, 04:35 AM

Would never I thought of that Roy

VBA Noob

**erock24** · 01-20-2008, 01:45 PM

VBA NOOB.

Code works perfect. Thank you.

Royuk,
I was unable to get your code to work??

Thank you both for your replies.

**royUK** · 01-20-2008, 02:11 PM

My code works fine in a test workbook.