Have a look at the Calculate Method in the VBA help, you can set it to
run on a workbook, single worksheet, or specified range.

hth

keith