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.

dual task command button that would stop some code running

Since you cannot run two macros at once it is not possible to have one macro
stop another.

--
Jim
"Saxman" wrote in message
...
|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.