How to create protected VBA project?

[Guest]

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

 

[Bill Renaud]

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).

 

[Guest]

Thanks Bill, I'll study those sites!
Stefi


„Bill Renaud†ezt írta: