Calling a sub

[ctor]

Say I wrote a sub, but the only whay to call it, at this moment, is via a button.
How can I treat this sub as a macro (my knowledge of terminology is lacking here)? What I mean by this is, the button has to leave and it has to be called (eventually) by an external program.
Any ideas?

[ctor]

Ah, I think I see, I've to program it as a separate module I guess?

[shg]

button has to leave and it has to be called (eventually) by an external program.

Can you elaborate on that?

[royUK]

You insert a Module & place the code into the module.

The button code will usually be in the sheet module