Hello -

I was wondering if there is a way to write a macro that imports updated
macros into the current Workbook?

I have played with VBProject.VBComponent as follows ...

lWB.VBProject.VBProject.VBComponents.Import YYY

The WWW file I created by exporting the code from Sheet1 of my Master
Macro.

Whenever I do the Import it adds the code under Class Modules instead
of replacing the code under Microsoft Excel Objects/Sheet1.

Is there a way that I can actually load a macro to be in the Sheets or
ThisWorkbook or will I have to move all of my code to a Module and put
"call Module1.XXX" calls in the X_Click() event handlers of my Sheet?

Thanks,
Joe

Thanks,
Joe