To run a macro:

Click Tools > VBA Macros > Manage > Run the macro you want from the list of macros you've created for the sheet.

You can also assign a macro to a button and run the macro just by clicking the button.

​