![Excel vba project unviewable unlock](https://kumkoniak.com/79.jpg)
Most people are aware of the option to password protect your code but this can be bypassed as shown in this blog. You can protect your macro (VBA code) in your MS Office documents from being view-able in the VBA Editor. It can be used on client sites by developers and by IT admins on user PCs to lock unviewable VBA projects in macro-enabled files.Ĭan a VBA project be viewable in MS Office? The EXE file is the windows application that will make macro-enabled Office Excel, PowerPoint and Word files unviewable in VBE. How to make an Excel spreadsheet unviewable in VBE? So let’s take a look at how easy it is to protect your VBA projects. This means that any edits you need to do to your VBA code will have to have been completed in your backup file and a new file will have to be put through Unviewable+.
![excel vba project unviewable unlock excel vba project unviewable unlock](http://www.wwww.spreadsheet1.com/uploads/3/4/3/6/34364573/3531203_orig.png)
How to protect your VBA project with unviewable +? Copy the below VBA code and paste in the module.Click OK, and then close and reopen the database.On the Protection tab, select the Lock project for viewing check box.
![excel vba project unviewable unlock excel vba project unviewable unlock](https://filedb.experts-exchange.com/incoming/2017/10_w41/1199552/1507980819745.jpg)
- 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. How do you make a project unviewable in VBA?