Su
Public Sub DeAttach()
Dim ws As Worksheet
Dim sh As Shape
For Each ws In ActiveWorkbook.Worksheets
For Each sh In ws.Shapes
sh.OnAction = ""
Next sh
Next ws
End Sub
In article ,
"marika1981" wrote:
Is there any way to De-Attach a Macro from a graphic button?? I need to
create a "macros-free" version of a spreadsheet I have with hundreds of macro
buttons (without deleting the buttons). I've deleted all the macros, but the
buttons still look for the non-existing macros.
Is there any way to keep the buttons but delete the macros????
|