lior03
01-09-2007, 12:54 AM
hello
i got the idea from my vba mentor johnske
i want to turn his macro
Sub AddFunctionDescription()
Application.MacroOptions _
Macro:="Test", _
Description:="This is a test"
End Sub
to a general way to add a macro description programatticlly
Sub addinn()
Dim x As String
Dim y As String
x = Application.Dialogs(xlDialogRun).Show
y = InputBox("please enter macro description")
Application.MacroOptions _
macro:="x", Description:="y"
End Sub
how do i can do it automatically
thanks
i got the idea from my vba mentor johnske
i want to turn his macro
Sub AddFunctionDescription()
Application.MacroOptions _
Macro:="Test", _
Description:="This is a test"
End Sub
to a general way to add a macro description programatticlly
Sub addinn()
Dim x As String
Dim y As String
x = Application.Dialogs(xlDialogRun).Show
y = InputBox("please enter macro description")
Application.MacroOptions _
macro:="x", Description:="y"
End Sub
how do i can do it automatically
thanks