查看完整内容
这个宏这样修改
Sub Mybutton()
Dim sht As Worksheet, btn As Button, An As Shape
For Each sht In Worksheets
With sht
For Each An In .Shapes '删除原有的按钮,避免重复创建
If An.Type = msoFormControl Then
If An.AlternativeText = "返回目录" Then An.Delete
End If
Next
Set btn = .Buttons.Add(0 ...