I would like to create a dual task command button that would stop some
code running and clear data on another worksheet. Or would it be best
to keep these operations separate?

Clearing the data could be done with a macro assigned to the command
button, but I'm not sure how I would go about stopping the code running.

Any help appreciated thanks.