Are you trying to secure a program you wrote in Visual Basic so that no one can copy it, send it to someone, and all other types of security protection? You will need an ultimate protection. You also want to exempt printing of this document code and even block any attempts to screen dump the code.
This would be Visual Basic code that makes up those macros for spreadsheets you will email to individuals. Some following tips are for protecting Visual Basic code in Microsoft Excel version 2000. Password protecting your code in excel is an option but this password could be crackable.
I found a solution to hide your Visual Basic code by creating an Microsoft Excel add in for your users. You can view this Visual Basic applications help article for protecting Visual Basic code in Microsoft Excel version 2000 from Microsoft support. If this is not sufficient enough security, you could create a dynamic link library file with your Visual Basic code and then have that Microsoft Excel spreadsheet call that specific dynamic link library file.
This would require writing your code in Visual Basic version 6.0 and learning how to call that code from within Microsoft Excel. You would create an add in for that Microsoft Excel spreadsheet and many users would not know it. It is still recommended to password protect that spreadsheet and create an add in.
You can check out this article explaining how to protect Visual Basic applications code in Microsoft Excel version 2007.
Need Online Computer Technical Support? Ask a Computer Technician Now and Solve Your Computer Problem!