Hai How r u?
i have my own add-in for somemacros. i want to add one more thing in my add-in,
is it possible to show running macro name in statusbar. i.e if user clicks on "change case" macro button, while running the macro, status bar will show the message " Running Change Case"
No, there is no ActiveMacro object or anything of that nature. When VBA converts you code to executable instructions, it doesn't use such things as names except during the translation.
You would have to put code to to that in each macro
Say you had a macro named Sub ChangeCase()
Sub ChangeCase() ' diplay name in StatusBar application.StatusBar = "ChangeCase is running" ' current code in ChangeCase
' Restore StatusBar to normal operation Application.StatusBar = False End Sub
Again, you would have to put code like that in every procedure.