Hi All,

I produce similar workbooks by copying a certain worksheet (containing event
macros) of a master workbook. How could I achieve that the result workbooks
be protected VBA projects?

Thanks,
Stefi

You might start by looking at the "Copy A Module From One Project To
Another" topic on the web page "Programming The VBA Editor"
(http://www.cpearson.com/excel/vbe.aspx) on Chip Pearson's web site.

Also, search for "VBComponent" on Chip's web site (or any MVP's web site;
see http://www.mvps.org/links.html#Excel).
--
Regards,
Bill Renaud

Thanks Bill, I'll study those sites!
Stefi


„Bill Renaudâ€� ezt Ã*rta:

> You might start by looking at the "Copy A Module From One Project To
> Another" topic on the web page "Programming The VBA Editor"
> (http://www.cpearson.com/excel/vbe.aspx) on Chip Pearson's web site.
>
> Also, search for "VBComponent" on Chip's web site (or any MVP's web site;
> see http://www.mvps.org/links.html#Excel).
> --
> Regards,
> Bill Renaud
>
>
>
>