Loading

Thursday, February 26, 2009

Protecting Excel VBA Macro Code

When we working with Excel VBA macro, sometimes we need to protect our VBA macro code. So nobody can change or modify VBA macro that we have create. Here are steps to protect VBA Project:

  • Go to Visual Basic Editor by pressing Alt+F11 key.
  • In menu toolbar, click Tools -> VBAProject Properties...

  • In VBAProject - Properties dialog box, click Protection tab, and then check Lock project for viewing checkbox.

  • Enter desired password to protect VBA project, then click OK button.
  • Save the VBA project.
FIN.

SHARE TWEET

Thank you for reading this article Protecting Excel VBA Macro Code With URL https://x-tutorials.blogspot.com/2009/02/protecting-excel-vba-macro-code.html. Also a time to read the other articles.

0 comments:

Write your comment for this article Protecting Excel VBA Macro Code above!