How I do Password protect a macro Code | How I do lock a module in excel vba | Bangla Tutorial
To password protect a macro code or lock a module in Excel VBA, you can follow these steps:
Open the Excel workbook that contains the VBA project you want to protect.
Press "Alt + F11" to open the VBA Editor.
Select the module or code that you want to protect by clicking on it in the Project Explorer window.
Click on "Tools" in the menu bar and select "VBAProject Properties."
Click on the "Protection" tab in the Project Properties window.
Check the "Lock project for viewing" box.
Enter a password in the "Password" field.
Confirm the password by re-entering it in the "Confirm password" field.
Click "OK" to apply the password protection to the VBA project.
Now, whenever someone tries to access the locked VBA project, they will be prompted to enter the password you set. If they do not know the password, they will not be able to view or modify the code.
Note that this password protection is not foolproof and can be bypassed by experienced VBA programmers. Therefore, it is recommended to keep a backup copy of the unprotected VBA project in a safe location in case you forget the password or need to make changes to the code.
By following these steps, you can password protect a macro code or lock a module in Excel VBA. For more detailed guidance on VBA password protection, you can refer to Excel VBA tutorials or videos available in different languages including Bengali (Bangla).
#Macro_Bangla_Tutorial #VBA_Bangla_Tutorial #Hasan_Acadmey
COMMUNICATE WITH HASAN ACADEMY
[email protected]
Facebook page
/ hasanacademybanglatutorial
Subscribe link : / @hasanacademy779
Facebook group link : / 282270382269650
Facebook page link : / hasanacademybanglatutorial
Most popular video Link :
• Excel VBA Bangla Tutorial 48 : Data E... • Excel VBA Bangla Tutorial 50 : Create... • Excel tutorial Bangla 24 : Top 10 Use... • Excel VBA Bangla Tutorial 54: Add- Em... • Introduction to Pivot Tables-Charts-a... • Excel VBA Bangla Tutorial 49 : Invoic...
Most of the people is think about that how I will learn .But they didn't get any idea & trustworthy source. Don't hesitated Hasan Academy with you. You will learn from here, Excel, Excel Chart, Pivot Table, Vlookup, Formula function