As long as your structure does not have blatant errors that prohibit the
macro from starting, you should be able to do one of the following.
From VBE:
place cursor in macro, press F5.
place cursor in macro, goto Run - Run Sub
From Workbook:
Press Alt+F8, choose macro, run
goto Tools - Macro - Macros, choose macro, run.
Note that all but the first option require that your sub be public, and not
private such as:
Private Sub MyMacro()
'Should be:
'Sub MyMacro()
'do something
End Sub
