How do I Call procedures from any worksheet. I don't want to have to cut and
paste the code every time.

DMB wrote:
How do I Call procedures from any worksheet. I don't want to have to cut and
paste the code every time.

If the sheet with the code is open it will be available. You can run it
from the macro list or assign a tool on a toolbar to run it. If you
want it aways available, put it in your PERSONAL worksheet.

If you want to call it within the same project (same workbook), then put it
in a general module (in the VBE=Insert=Module).

Then it will be visible throughout the project if you do not declare it as
private.

--
Regards,
Tom Ogilvy

"DMB" wrote in message
...
How do I Call procedures from any worksheet. I don't want to have to cut
and
paste the code every time.