1. 宏的制作
Sub 調整多个圖片大小()
'
' Keyboard Shortcut: Ctrl+Shift+S
'
Dim shp As Variant
If TypeName(Selection) = "Range" Then
MsgBox "請僅選擇一個對象。", vbCritical
Exit Sub
End If
For Each shp In Selection.ShapeRange
'此處的0.6表示圖片縮小60%
shp.Height = shp.Height * 0.6
Next
End Sub