Data-Chart-Export
Option Explicit

Private Sub Worksheet_FollowHyperlink(ByVal Target As Hyperlink)

    Select Case Target.Range.Value
    
        Case "Export_Charts"
        
            Dim s_SubFolder As String
            s_SubFolder = VBA.Format(Now(), "yyyymmdd_hhmmss")
            Dim s_prefix As String
            s_prefix = ""
            Dim s_suffix As String
            s_suffix = ""
            
            ' Expand all, else chart exported is not visible
            Me.Outline.ShowLevels RowLevels:=0, ColumnLevels:=2
            
            Call Worksheet_ChartObjects_ExportAll(Me, "png", s_SubFolder, s_prefix, s_suffix)
        
        Case Else
            ' Nothing
            
    End Select

End Sub