• Status: Solved
  • Priority: Low
  • Security: Public
  • Views: 84
  • Last Modified:

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.
Milan Soni
Milan Soni
1 Solution
ShumsDistinguished Expert - 2017Commented:
Hi Milan,

Follow this link, which may guide you.

Hope this helps
Rob HensonFinance AnalystCommented:
In the Visual Basic Editor you can protect each module with a password. By doing so only users that know the password can open the module.

This is a limited form of protection as Excel passwords are not the most secure but it would stop any casual prying.
Martin LissOlder than dirtCommented:
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.
Milan SoniAuthor Commented:
This was helpful.
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Ultimate Tool Kit for Technology Solution Provider

Broken down into practical pointers and step-by-step instructions, the IT Service Excellence Tool Kit delivers expert advice for technology solution providers. Get your free copy now.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now