Windows Zoom
I have a table on one sheet with a list of sheet names and the desired zoom
(for display not printing) for each sheet. How can I set the zoom without selecting each sheet? DO I have to make each sheet active first? Thanks, Kaval |
Windows Zoom
"Kaval" wrote in message
... I have a table on one sheet with a list of sheet names and the desired zoom (for display not printing) for each sheet. How can I set the zoom without selecting each sheet? DO I have to make each sheet active first? Hi Kaval, Yes, you must active each sheet before settings its zoom. The Zoom property is actually a property of the Window object, so it only applies to the sheet currently being displayed in the Window. -- Rob Bovey, Excel MVP Application Professionals http://www.appspro.com/ * Take your Excel development skills to the next level. * Professional Excel Development http://www.appspro.com/Books/Books.htm |
All times are GMT +1. The time now is 08:32 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com