If you are building a macro and don't want any one to modify it. You have an option in Excel VBA editor, using which you can protect your VBA module code.
Open a new excel file
Go to Visual Basic Editor Window.
Insert new module and add a sample code to it.
Sub SampleCode()
Msgbox "This is a sample code we need to hide !", vbInformation
End Sub
Follow the below steps to protect the VBA module:
Click on Tools
Click on VBA Project Properties
The VBA object properties window will pop up. On this window, select the Protection Tab.
Click on Lock Project for viewing check box
Enter the password of your choice in two fields, Password and Confirm Password.
Open a new excel file
Go to Visual Basic Editor Window.
Insert new module and add a sample code to it.
Sub SampleCode()
Msgbox "This is a sample code we need to hide !", vbInformation
End Sub
Follow the below steps to protect the VBA module:
Click on Tools
Click on VBA Project Properties
The VBA object properties window will pop up. On this window, select the Protection Tab.
Click on Lock Project for viewing check box
Enter the password of your choice in two fields, Password and Confirm Password.
Click OK and we have just protected the VBA module. Save and close the workbook. Open it again to check the protection.
Go to VBA module, all modules will be hidden and if you double click on it will ask you the password to unprotect.
Also check out my posts on :
- How to split or delimit data using Excel VBA code ...
- Must know VBA functions in Excel VBA
- What are Objects, Properties and Methods in Excel ...
- How to use comments in the Excel VBA Macro ?
- How to edit and debug the macro created in Excel V...
No comments:
Post a Comment