Very easy:

Construct the Workbook Activate sub to do nothing other than call another
public sub in a standard module. This "other" sub will do the real work.

In this way the "other "sub will be available to other projects/modules.


--
Gary's Student
gsnu200704


"joeeng" wrote:

Is there a way to manually run the Workbook_Activate event procedure from
another workbook without actually activating the workbook?