如何把EXCEL中所有图片的超链接批量删除?

2025-04-03 20:07:35
推荐回答(2个)
回答1:

可以用VBA来做:
按Alt+F11打开VBA编辑器,插入——模块,将下面的代码粘贴进去,按F5运行就可以了:
Sub
aa()
For
Each
s
In
ActiveSheet.Shapes
s.Hyperlink.Delete
Next
End
Sub

回答2:

Sub
aa()
Dim
sht
As
Worksheet
Dim
shp
As
Shape
For
Each
sht
In
Sheets
For
Each
shp
In
sht.Shapes
shp.Hyperlink.Delete
Next
Next
End
Sub
用上面的宏可以去掉,原理请自行研究,一两句话解释不清。