Skip to content

Instantly share code, notes, and snippets.

@book000
Last active March 22, 2024 09:16
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save book000/865813bf08dbab1383dde3d10d79d2c9 to your computer and use it in GitHub Desktop.
Save book000/865813bf08dbab1383dde3d10d79d2c9 to your computer and use it in GitHub Desktop.
すべてのシートを「倍率100%」「アクティブセルA1」「標準ビュー」にする
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