How do I fix an unviewable project?
Project Is Unviewable
- Save your Workbook as (. xlam)
- Lock the VBAProject. Press Alt+F11 to open the Visual Basic Editor.
- Change the isAddin property. Double click on the add-in (.
- Share the Workbook. Select File, Options and select Quick Access Toolbar.
- Resave the Workbook as an Add-in – Not Working. Save the Excel (.
Why is my VBA project unviewable?
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. This feature is documented as the ProjectProtectionState and ProjectVisibilityState attributes of the PROJECT stream in Office files here.
How do I make VBA project unviewable?
Workbook Is In Shared Mode Use our Macro Mover add-in to unlock VBA in a Shared workbook. Unshare the workbook from: Review Tab > Unshare Workbook.
How do I unlock a locked VBA project?
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. 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.
Can you edit MACRO, project is unviewable [ solved ]?
I only edit this macro once a year so this is the first time I noticed that I can’t edit it. When I click the project in VBA I get: Project locked/project is unviewable. It’s not a shared workbook.
What does it mean when project is unviewable in Excel?
I’ve converted a shared workbook (in which the project was unviewable) to an add-in and the project became viewable again. Has anyone encountered this before? I’m interested in being able to protect my own projects this way if possible.
How to make a project locked and unviewable?
There is also a password-less protection option that simply tells the user that the Project is locked and “unviewable” as shown in the image below. 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.
Can a VBA project be viewable in MS Office?
You can protect your macro (VBA code) in your MS Office documents from being view-able in the VBA Editor. Most people are aware of the option to password protect your code but this can be bypassed as shown in this blog.