Sub 宽大小单值()
'
' 宽大小单值 宏
'
'
Dim n '图片个数
Dim p
p = InputBox("输入宽度:厘米")
Dim picwidth
Dim picheight
On Error Resume Next '忽略错误
For n = 1 To Selection.InlineShapes.Count 'InlineShapes类型图片
ishape.LockAspectRatio = msoTrue
picheight = Selection.InlineShapes(n).Height
picwidth = Selection.InlineShapes(n).Width
Selection.InlineShapes(n).Width = p * 28.345 '设置宽度为0.5倍
Next n
End Sub
Sub 高大小单值()
'
' 大小单值 宏
'
'
Dim n '图片个数
Dim p
p = InputBox("输入宽度:厘米")
Dim picwidth
Dim picheight
On Error Resume Next '忽略错误
For n = 1 To Selection.InlineShapes.Count 'InlineShapes类型图片
ishape.LockAspectRatio = msoTrue
picheight = Selection.InlineShapes(n).Height
picwidth = Selection.InlineShapes(n).Width
Selection.InlineShapes(n).Height = p * 28.345
Next n