![]() Otherwise, you can just run, but not view, the modules. If you type the correct password, you will be given an access to the project code. Clicking on the create button will ask you for the password.If we want to create / edit, we can type a new procedure name in that edit box as below.But we see that all buttons except “Run” are disabled. On opening a workbook which contains a password protected VBA project, we may try to view or edit the code of any module.For this to work, the Excel workbook has to be closed and re-opened. Click on the ok button and close the dialog box.Enter a password and confirm the same in the second text box too. Select the “Lock project for viewing” option.Select the “Protection” tab in the “VBAProject – Project Properties” window.Right click on the VBA Project in the Project Explorer.This can be done through the following steps. Just like how Excel offers protection to its sheets / data using passwords, it is possible to protect a VBA project’s code too. Extraction of source code from the VBAProject.bin file:.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. Archives
June 2023
Categories |