excel插入图片自动适应表格大小
1 ALT + F112菜单 插入-----模块3键入Sub PictureFitUnit() Dim sh As Shape For Each sh In ActiveSheet.Shapes sh.LockAspectRatio = False sh.Left = sh.TopLeftCell.Left
·
1
ALT + F11
2
菜单 插入-----模块
3
键入
Sub PictureFitUnit()
Dim sh As Shape
For Each sh In ActiveSheet.Shapes
sh.LockAspectRatio = False
sh.Left = sh.TopLeftCell.Left
sh.Top = sh.TopLeftCell.Top
sh.Width = sh.TopLeftCell.Width
sh.Height = sh.TopLeftCell.Height
Next sh
End Sub
4
光标在模块中,F5执行
更多推荐
已为社区贡献1条内容
所有评论(0)