Maybe this...
See 'Copy A Module From One Project To Another'
http://www.cpearson.com/excel/vbe.htm

HTH,
Ryan---

--
Ryan---
If this information was helpful, please indicate this by clicking ''Yes''.


"N Selinger" wrote:

When you "Move or Copy" a worksheet to its own file (workbook), the macro
project lock/password does not get passed to the new file (macros in the new
file ARE able to be viewed/edited). Is there a way to programmatically lock
and/or unlock the macro project?

--
N Selinger