Milan Soni
asked on
How to hide/lock macro and its codes?
I want to provide the user with the macro in an excel but I do not want them to see my macro codes, is it possible? if yes please suggest.
I want to implement this in Excel and word application both.
I want to implement this in Excel and word application both.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
To protect the code, open the Excel Workbook and go to Tools>Macro>Visual Basic Editor (Alt+F11). Now, from within the VBE go to Tools>VBAProject Properties and then click the Protection page tab and then check "Lock project from viewing" and then enter your password and again to confirm it.
ASKER
This was helpful.
This is a limited form of protection as Excel passwords are not the most secure but it would stop any casual prying.