PDA

View Full Version : Sleeper: Locking project after importing



everytime
08-18-2005, 05:24 AM
hi there , i have many forms , modules and the menu code in the thisworkbook , how do i have 1 file to import all of them into other excel files ?? or would a addin do the trick ??

1 more thing how to lock the vbaproject after importing ?

royUK
08-18-2005, 05:36 AM
Cross posting again

http://www.ozgrid.com/forum/showthread.php?t=38350

Killian
08-18-2005, 06:07 AM
I would suggest an AddIn is the way to go
Then lock it from the VBE Tools>VBA ProjectProperties>Proctection... check Lock Project for Viewing and add a password