I have many macros in a workbook but only 7 or 8 are normally used. Sometimes the particular macro name needed is lost in this list of macros. I added a worksheet (named "DOC") which lists the most common macros with a brief description of their function. Now I'd like to highlight the macro name I want and call it. Although the following code doesn't do this, it has the same problem. How do I fix it?

The code asks the user for a macro name and then attempts to call that macro. It gets a compile error because the variable name for the macro isn't allowed. If I can get this to work, I can solve the real problem.

Sub VarMac()

Dim macName as String

macName = InputBox("Please enter the macro name.")

MsgBox macName

Call macName

End