Does anyone know how to remove the entire vba project (vbe) from one
workbook?

Then, load it into another workbook on its workbook open event?

Thanks for any help you could give me.

Coby.

The VBAProject is the workbook and I don't believe you can remove a workbook
from a workbook.

You could remove Modules from the VBAProject then add them to another workbook.

Chip, or is it Chuck<g Pearson has instructions for adding/deleting modules.

http://www.cpearson.com/excel/vbe.aspx


Gord Dibben MS Excel MVP

On Wed, 23 Jan 2008 14:33:21 -0800 (PST), Coby
wrote:

Does anyone know how to remove the entire vba project (vbe) from one
workbook?

Then, load it into another workbook on its workbook open event?

Thanks for any help you could give me.

Coby.

On Jan 23, 2:33*pm, Coby wrote:
Does anyone know how to remove the entire vba project (vbe) from one
workbook?

Then, load it into another workbook on its workbook open event?

Thanks for any help you could give me.

Coby.

O.k. that is a wealth of information and I appreciate it.
Thanks,

Coby.