Zoom size adaption

[wilwhiting]

I have the code for changing all my worksheets within the workbook to a certain zoom size. I would like to specify a couple of worksheets that i dont want the zoom size to change. Please can you help me to adapt the code to let me acheive this?

Please Login or Register  to view this content.

[mudraker]

This example uses a select case statement to list the sheets names that you do not want the code to run on.

Bote:- the command is case senesitive & I have coded it to use lower case comparison

Please Login or Register  to view this content.

[wilwhiting]

Thanks for the quick reply, works great!