Hi,
I'd like to adjust the zoom level from a macro to allow for different screen sizes amongst users.
If there a way to adjust several (but not all) worksheets from the one command, rather than making each sheet the active sheet, adjusting the zoom, then changing to the next worksheet and repeating the process?
This is what I'm using now...
Please Login or Register to view this content.
Last edited by EdWoods; 05-08-2013 at 10:27 PM.
Set loop for all worksheets
Please Login or Register to view this content.
Last edited by humdingaling; 05-08-2013 at 09:47 PM. Reason: additional info
This still selects your specific sheets but it does it en mas instead of one at a time. Adjust\Add your specific sheet names to suit.
Please Login or Register to view this content.
Perfect. Thanks yet again!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks