lior03
07-15-2005, 12:17 PM
hello
the following macro run a specific macro from a list
on a worksheet.
how can i add a msgbox to tell the user he chose a wrong name.
secondly , is ther a way to delete a macro from the vba
editor.namely if i can run it can i delete it.
thanks
Sub testers2()
On Error GoTo canceled:
Dim y As String
y = InputBox("select macro to run ", "a macro runner")
With Application
.Run y
End With
canceled:
End Sub
the following macro run a specific macro from a list
on a worksheet.
how can i add a msgbox to tell the user he chose a wrong name.
secondly , is ther a way to delete a macro from the vba
editor.namely if i can run it can i delete it.
thanks
Sub testers2()
On Error GoTo canceled:
Dim y As String
y = InputBox("select macro to run ", "a macro runner")
With Application
.Run y
End With
canceled:
End Sub