after editing a macro what do i need to do before it iwll run again?

Click Run, Reset.

confused!! wrote:

after editing a macro what do i need to do before it iwll run again?

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

--
Best Regards,

Luke M
*Remember to click "yes" if this post helped you!*


"confused!!" wrote:

after editing a macro what do i need to do before it iwll run again?