|You can create a button specific to the worksheet in question and then assign the macro to it.|
You can set it up so that a change to specific cell or cells causes the macro to run automatically.
You can create a tool bar button that will make the macro available in any and all workbooks.
You can...well there's lots of other things you can do to "call" the macro from within a spreadsheet.
If you'll provide some details, we can make a more specific suggestion.
Click Here Before Posting Data or VBA Code ---> How To Post Data or Code.