首页 > 分享 > Excel图片调整大小

Excel图片调整大小

最新推荐文章于 2022-06-18 15:07:35 发布

zhanglei1371 于 2017-03-31 19:36:43 发布

版权声明:本文为博主原创文章,遵循 CC 4.0 BY-SA 版权协议,转载请附上原文出处链接和本声明。

Sub 图片调整合适大小()

图片显示比例 = 0.9

Dim wb As Workbook, sh As Worksheet, ce As Range, shp As Shape

Dim dic As Object, re As Object, shel As Object, WS As Object, FSO As Object

Dim arr(), brr()

Set dic = CreateObject("scripting.dictionary")

Set wb = ActiveWorkbook

Set sh = wb.Sheets(1)

For Each shp In sh.Shapes

With shp

shp.Name = shp.Name & Round(Rnd() * 125, 1)

shp.Top = shp.Top + shp.Height / 2

shp.Left = shp.Left + shp.Width / 2

shp.Height = shp.Height / 8

shp.Width = shp.Width / 8

wt = shp.TopLeftCell.MergeArea.Width

ht = shp.TopLeftCell.MergeArea.Height

bl = .Width / .Height

If wt / ht < bl Then

.Width = wt * 图片显示比例

.Height = .Width / bl

.Left = shp.TopLeftCell.MergeArea.Left + (wt - .Width) / 2

.Top = shp.TopLeftCell.MergeArea.Top + (ht - .Height) / 2

Else

.Height = ht * 图片显示比例

.Width = .Height * bl

.Top = shp.TopLeftCell.MergeArea.Top + (ht - .Height) / 2

.Left = shp.TopLeftCell.MergeArea.Left + (wt - .Width) / 2

End If

End With

Next

End Sub

相关知识

在Excel中,如何对时间序列数据进行季节性调整
Excel库存管理系统,Excel仓库出入库记账管理表格
day14:python读取excel文件数据
Excel这个排序功能,大部分人都没用过
EXCEL VBA培训班
PS如何调整图片光照效果?
数据分析入门:15种EXCEL数据分析功能
PS调整油菜花图片的光线与色彩
通用Excel库存管理系统,最好用的Excel出入库管理表格
Excel下拉菜单自动颜色设置指南(excel下拉菜单自动颜色)

网址: Excel图片调整大小 https://m.huajiangbk.com/newsview816487.html

所属分类:花卉
上一篇: 建筑适应环境概要.ppt
下一篇: 瓜帅:顶级球员更快适应新环境,沃