Last active
July 17, 2022 05:00
-
-
Save object1985/c5fdbc012994a1cad9b0b0825e0362b9 to your computer and use it in GitHub Desktop.
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
Sub setAllSheet_zoomAndFirstSheetSelect() | |
zoomValue = InputBox("ZOOM倍率を10~100で入力してください", "", 100) | |
If zoomValue = "" Then | |
Exit Sub | |
End If | |
'イミディエイトウィンドウで以下を実行 | |
'全シートに対して繰り返しzoom(倍率)を設定する(数値は適宜修正すること) | |
'また最後に1シート目を選択するようにしている。 | |
'非表示シート、保護シートへの制御はないので適宜確認すること。 | |
For Each i In Worksheets: i.Select: ActiveWindow.Zoom = zoomValue: i.activate:Application.Goto Reference:=Range("A1"), Scroll:=True::next i | |
Sheets(1)..Select | |
End Sub |
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment