Last active
March 22, 2024 09:16
-
-
Save book000/865813bf08dbab1383dde3d10d79d2c9 to your computer and use it in GitHub Desktop.
すべてのシートを「倍率100%」「アクティブセルA1」「標準ビュー」にする
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 Zoom100CursorA1NormalView() | |
' ScreenUpdatingを切るとA1セルがアクティブにはなるが、表示範囲が変わらない | |
Dim sheet As Object | |
For Each sheet In ActiveWorkbook.Sheets | |
sheet.Activate | |
ActiveSheet.Range("A1").Select | |
ActiveWindow.Zoom = 100 | |
ActiveWindow.View = xlNormalView | |
Next sheet | |
Sheets(1).Select | |
End Sub |
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment
ref: https://note.com/sheep_0411/n/n4b0732163b01 https://tripbowl.com/excel-vba/pagebreakpreview/