Last active
March 23, 2024 09:12
-
-
Save NonAbility/5be9a1591dd9facb51828b7d7fba2a4e 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
Option Explicit | |
Private Sub Worksheet_PivotTableChangeSync(ByVal Target As PivotTable) | |
' | |
' 日スライサーが変更されたときに実行するマクロ | |
' | |
Call ScrOff | |
Call Ref2 | |
Call ScrOn | |
Call Save | |
End Sub |
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment