![]() On the Tools menu, select Properties….In Access, press ALT+F11 to open the VBA editor.You can also open VBA in Excel using Alt + F11 keyboard shortcut. If the Developer tab is not present, go to File -> Options -> customize ribbon and tick Developer. To open Excel visual basic editor, Click the visual basic button on the developer tab. Now if anyone wants to view the vba files they need a password first. Right click the VBAproject and click ‘Project Properties’ then select Protection tab and check ‘lock project for viewing’ and set a password. 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. To protect your code, open the Excel Workbook and go to Tools>Macro>Visual Basic Editor (Alt+F11). To return to the worksheets, close out of the VBE by clicking on the X in the upper right corner, or by pressing Alt+Q. To unlock it, click on Tools > VBA Project Properties, choose the Protection tab, deselect the “Lock project for viewing” box, and clear the two password fields. This feature is documented as the ProjectProtectionState and ProjectVisibilityState attributes of the PROJECT stream in Office files here. The unviewable option is not able to be set through the MS office application itself, but instead, it needs to be done as a modification to the file after it is saved. Resave the Workbook as an Add-in – Not Working.Select File, Options and select Quick Access Toolbar. Press Alt+F11 to open the Visual Basic Editor. Mail me if you have any query or suggestions regarding this.How do you make a project unviewable in VBA? Reply back to me if you need to know passwords for different file formats. Following are the steps to accomplish this little trick:ġ) Make a copy of excel file for which you need to find the VBA password (This is just for future recovery just in case the conversion fails)Ģ) Create a new excel file and set VBA password (eg: testpwd)ģ) Download any HEX editor like "Hex-editor XVI32"Ĥ) Open the source file and newly created excel file using this editorĥ) Find following string CMG=" and copy the hex code till double quote endsĦ) Paste it in the source file at same CMG=" locationħ) Repeat steps 5 and 6 for search string DPB=" and GC="Ĩ) Open the source file and enter VBA password 'testpwd' to open the VBA editor. I was thinking about finding the password for these many days but later found that we could change it the way we want. I was able to figure out a way to do this in unique style. ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. Archives
March 2023
Categories |