Windows Zoom Settings

nigelandrewfoster

Well-known Member
Joined
May 27, 2009
Messages
747
Hi, a few things re: windows have been puzzling me recently.
Q. 'Zoom' is a property of a window, but am I correct in saying it only affect the SHEET that is active in the window at the time the property is applied?
Thanks,
Nigel
 

Excel Facts

Remove leading & trailing spaces
Save as CSV to remove all leading and trailing spaces. It is faster than using TRIM().
If you want to zoom all sheets try this I have this code behind the workbook event on Open.

Zoom all sheets to 85% percent in a workbook
Private Sub Workbook_Open()
'***********************************************************
'The following code changes the zoom control on all sheets to 85%
'Created by Trevor G - April 2011
'The purpose is to zoom all sheets to 85%
'************************************************************
Application.ScreenUpdating = False
Dim wksht As Worksheet
For Each wksht In Worksheets
wksht.Activate
ActiveWindow.Zoom = 85
Range("A1").Select
Next wksht
'Sheets("welcome").Select
Application.ScreenUpdating = True
MsgBox "All sheets resized to 85%", vbInformation, "Trevor G"
End Sub
 
Upvote 0
Hi, a few things re: windows have been puzzling me recently.
Q. 'Zoom' is a property of a window, but am I correct in saying it only affect the SHEET that is active in the window at the time the property is applied?
Thanks,
Nigel

"ActiveWindow.Zoom =" affects the active sheet(s).
eg:
Sheets(Array("Sheet1", "Sheet2", "Sheet3")).Select followed by zoom will affect all the 3 sheets.
If only one sheet is selected, then the zoom for that sheet will be affected.
 
Upvote 0
Thanks for that. It was confusing me. Does anyone know if there are any other "window" properties that only affect the active sheet? Now, if the VBA help had warned me of that...
 
Upvote 0

Forum statistics

Threads
1,223,460
Messages
6,172,333
Members
452,454
Latest member
MadamRedRabbit

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top