Setting zoom for all worksheet pages
Hi david,
Try putting your code into a For..Each..Next statament. Dim ws As Worksheet For Each ws In Worksheets If ws.Name < mSheet Then ws.Activate ....<Your code here End If Next ws HTH's Russell.(Skmr3) -----Original Message----- I have built a mutipage management reporting package, but have run into one problem I don't know how to fix. I have designed all information views to fit on one screen, and to require no scrolling. Unfortunately, not all of my users can see the same amount of information on their screens as I do. Since I do not expect that they will want to use Zoom on each page, I am trying to figure out how to write a macro that will allow the user to fill in a Zoom percentage on a screen I design, check to see that the appropriate range is displayed, and then adjust the views on all pages accordingly. I have figured out how to do this one page at a time, but wonder if there is a way to do this to the entire workbook. Any help will be greatly appreciated. . |
All times are GMT +1. The time now is 04:27 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com