Running VBA Code not written within the currrent worksheet
 

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

Running VBA Code not written within the currrent worksheet
 

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.

Running VBA Code not written within the currrent 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.