Protecting vba codes of worksheets copied from Addin

[mathsbeauty]

Hello! I have addin containing several worksheets. The addin is an xlam file in excel 2007. Some of the worksheets contain vba codes (such as worksheet selection change event) in the sheet code module.The vba project of the add in is password protected. Some worksheets from the addin get copied to the current active workbook. The vba modules of addin can not be viewed because they are password protected. However the sheet codes of the copied worksheets from addin can be viewed. How can I password protect these worksheets codes?

 

[kpark91]

In your VBE, go to
Tools/VBA Project Properties/Protection tab/"Lock project from viewing"

Type in your password and then save and close
then reopen and it should be okay :P

 

[kpark91]

Also, I'm not too sure but use this program (trial for 30 days)

http://www.dombajsoft.com/protectvba.htm

 

[mathsbeauty]

Thanks kpark91 for reply. The vba project is already locked for viewing. The problem is to protect the worksheet codes which get copied from addin to the current workbook.