Hi All,
I have still cannot get it right after some advice from Norman and other
experts.

I would like to write a macro and put it in Workbook 1. This macro in
workbook 1
will help mi to delete all the modules in Workbook 2.

Eg.
Workbook 2 modules are 1) "A_SortData", 2) "B_CreateMonthlyYield"

So what can anybody tell me what to write for the macro to place in workbook
1
to delete the 2 modules stated above in workbook 2???