我有一个VBA代码,可以根据屏幕分辨率设置缩放级别。 但是它只在打开工作簿时对ActiveWindow有效。 如何将其应用到Excel中的所有工作表?
Declare Function GetSystemMetrics32 Lib "user32" _
Alias "GetSystemMetrics" (ByVal nIndex As Long) As Long
Public Sub ScreenRes()
Dim lResWidth As Long
Dim lResHeight As Long
Dim sRes As String
lResWidth = GetSystemMetrics32(0)
lResHeight = GetSystemMetrics32(1)
sRes = lResWidth & "x" & lResHeight
Select Case sRes
Case Is = "800x600"
ActiveWindow.Zoom = 75
Case Is = "1024x768"
ActiveWindow.Zoom = 125
Case Else
ActiveWindow.Zoom = 100
End Select
End Sub
我会在工作簿上调用这个模块。
Private Sub Workbook_Open()
ScreenRes
End Sub