非常感谢版主的多次帮助,但我使用下面的宏时只能删去当前工作表的按钮,不能删除当前工作薄的所有按钮,怎么改呢,谢谢!
Sub MacroDelFor Each ms In ActiveSheet.Shapes ms.DeleteNext msEnd Sub
Sub MacroDel()
For Each Sht in worksheets For Each ms In sht.Shapes ms.Delete Next ms
next ShtEnd Sub
使用道具 举报
本版积分规则 发表回复 回帖后跳转到最后一页
小黑屋|手机版|Archiver|Excel精英培训 ( 豫ICP备11015029号 )
GMT+8, 2024-5-16 16:14 , Processed in 0.235857 second(s), 7 queries , Gzip On, Yac On.
Powered by Discuz! X3.4
Copyright © 2001-2020, Tencent Cloud.