Excel VBA Project Is Unviewable: Causes and Fixes

Few things in Excel are more frustrating than pressing Alt + F11 to edit your code and seeing the error “Project Is Unviewable.” It can be confusing, especially when you created the workbook yourself or when the macros are still running.

This error can have several causes, including workbook sharing restrictions, VBA project protection, or problems with the file. In this guide, you will learn what the error means and how to fix it step by step.

What Does “Project Is Unviewable” Mean?

The “Project Is Unviewable error"appears when Excel does not allow you to view a VBA project in the Visual Basic Editor (VBE). Your macros may still run, but you might not be able to view or edit the code.

This message does not always mean that your VBA code is missing or damaged. The cause may be a workbook setting, a protection feature, or a problem with the file.

You may also see a message such as “Project Locked” when a VBA project is protected with a password. These messages are different, so it is important to identify the problem before trying a fix.

The Most Common Causes

The following issues may prevent you from viewing or editing a VBA project in Excel:

• The workbook uses the legacy Shared Workbook feature or has sharing restrictions.

• The VBA project is protected with a password.

• Excel is blocking access because of security settings or file restrictions.

• The workbook is open in another Excel window or instance.

• The file is read-only or you do not have permission to edit it.

• The workbook was saved in a format that does not support VBA code.

• The workbook or its VBA project may be damaged.

Understanding the possible cause will help you choose the right solution.

How to Fix the Excel VBA Project Is Unviewable Error

Try the following methods in order. Before making changes, create a backup copy of your workbook so that you do not lose important data or code.

1. Remove Legacy Workbook Sharing Restrictions

The legacy Shared Workbook feature in Excel can restrict certain editing features, including changes to VBA code. If your workbook uses this feature, removing the sharing restriction may help.

Follow these steps:

1. Open your workbook in the Excel desktop application.

2. Go to the Review tab.

3. Look for Share Workbook or the legacy sharing options. Their location may vary by Excel version.

4. If the workbook uses the legacy Shared Workbook feature, open its sharing settings.

5. Clear the option that allows changes by more than one user at the same time, if available.

6. Confirm the change and save the workbook.

7. Close and reopen the workbook.

8. Press Alt + F11 to check whether you can view the VBA project.

Important: Save a backup before removing sharing settings. If you cannot find these options, your Excel version may not support the legacy feature in the same way. Do not assume that sharing is the cause if the option is missing.

2. Check Whether the VBA Project Is Password-Protected

A VBA project may be protected with a password to prevent other users from viewing its code. If you do not know the password, you may not be able to access the project.

Follow these steps:

1. Open the workbook in Excel.

2. Press Alt + F11 to open the Visual Basic Editor.

3. Look for the VBA project in the Project Explorer.

4. If Excel asks for a password, enter the correct password.

5. If you do not know the password, contact the person who created or protected the workbook.

If you have forgotten the password for your own workbook, you can consider a suitable VBA password recovery tool.

Use PCVITA VBA Password Remover

If you have forgotten the password for a VBA project and cannot access its code, PCVITA VBA Password Remover is a software option to consider for password-related access problems.

Before using a password recovery tool, make a backup of your original Excel workbook. Check the tool's supported file formats and protection types to confirm that it meets your needs.

Important: A VBA password recovery tool may not fix the “Project Is Unviewable” error if the cause is workbook sharing restrictions, file damage, or another Excel setting. Use the tool only for files you own or are authorized to access.

3. Check the Trust Center Settings

Excel has a security setting called “Trust access to the VBA project object model.” It controls whether other programs or VBA code can access and modify VBA projects programmatically.

This setting is not normally required just to view a project manually in the Visual Basic Editor. However, if you are using a macro or an application that accesses VBA projects, checking this setting may help.

Follow these steps:

1. Open Excel.

2. Go to File > Options.

3. Select Trust Center.

4. Click Trust Center Settings.

5. Open Macro Settings.

6. Find the option “Trust access to the VBA project object model.”

7. Enable it only if your task requires programmatic access and you trust the workbook and the code.

8. Click OK to save your changes.

Restart Excel if necessary and try again.

Security note: Do not lower Excel's security settings unnecessarily. Enabling access to the VBA project object model can allow trusted code to make changes to VBA projects, so only enable it when required.

4. Unblock the File and Exit Protected View

Excel may open files downloaded from the internet or received through email in Protected View. This mode limits certain actions to help protect your computer.

If Excel shows an Enable Editing button or a security warning, check whether the file is restricted.

Follow these steps:

1. Open the workbook in Excel.

2. If a Protected View warning appears, verify that the file is safe.

3. Click Enable Editing only if you trust the file and its source.

4. If the problem continues, close Excel.

5. Open File Explorer and locate the workbook.

6. Right-click the file and select Properties.

7. On the General tab, look for an Unblock option.

8. If the option is present and you trust the file, select it.

9. Click Apply and OK.

10. Reopen the workbook and check the VBA project.

Unblocking a file will not fix every VBA project error. If the workbook is not restricted by Protected View or file blocking, try another method.

5. Check Whether the Workbook Is Read-Only or Open Elsewhere

A read-only workbook or a file that is open in another Excel instance may prevent you from making changes. However, read-only status alone does not usually stop you from viewing VBA code.

Follow these steps:

1. Save your work and close the workbook.

2. Close other Excel windows that may have the same file open.

3. Open Task Manager and check whether Excel is still running. Make sure you do not have unsaved work before ending any Excel process.

4. Locate the workbook in File Explorer.

5. Right-click the file and select Properties.

6. If the Read-only attribute is selected, clear it if you have permission to modify the file.

7. Click Apply and OK.

8. Reopen the workbook and press Alt + F11.

If the file is stored on a shared network location, check whether you have the required permissions and whether another user is editing it.

6. Check the Workbook File Format

Excel uses different file formats for workbooks with and without VBA code.

• .xlsx: Supports standard Excel workbook data but does not retain VBA macros.

• .xlsm: Supports Excel workbooks that contain VBA macros.

• .xlsb: Supports Excel workbooks in binary format, including VBA macros.

If your workbook contains VBA code, it should normally be saved in an appropriate macro-enabled format.

Follow these steps:

1. Open the workbook in Excel.

2. Select File > Save As.

3. Choose a suitable location.

4. Select Excel Macro-Enabled Workbook (*.xlsm) from the file type list.

5. Save the workbook under a new name.

6. Close and reopen the saved file.

7. Press Alt + F11 and check the VBA project.

Important: Saving an existing .xlsx file as .xlsm does not restore VBA code that was previously removed. If the original workbook was saved as .xlsx after containing macros, check for an earlier macro-enabled copy or a backup.

7. Check Excel Version Compatibility

A workbook created in a newer version of Excel may use features that are not fully supported in an older version. This can sometimes cause compatibility problems.

However, an older Excel version does not automatically make every VBA project unviewable.

Follow these steps:

1. Check which version of Excel you are using.

2. Ask the workbook's creator which version was used to create the file, if possible.

3. Open the workbook in a supported, updated version of Excel.

4. Check whether the same error appears.

5. If the problem continues, ask the creator for an unprotected copy or a version saved in a compatible format, if they can provide one.

Do not assume that changing the Excel version will solve the problem. The cause may be related to project protection, sharing restrictions, or file damage instead.

8. Repair the Workbook

If none of the previous methods works, the workbook may be damaged. Excel includes an Open and Repair feature that can attempt to recover a damaged workbook.

Follow these steps:

1. Open Excel.

2. Go to File > Open > Browse.

3. Find and select the affected workbook.

4. Click the arrow next to the Open button.

5. Select Open and Repair.

6. Choose Repair when prompted.

7. If Excel cannot repair the workbook, try the Extract Data option if it is available.

8. Save any recovered content to a new file.

After the repair, check whether the workbook opens correctly and whether the VBA project is available.

Important: Open and Repair may not recover every part of a damaged workbook. It may also fail to restore a VBA project that has been removed or is protected by a password. Keep the original file unchanged until you have checked the recovered copy.

Prevention: How to Avoid This Error in the Future

You can reduce the chances of facing the “Project Is Unviewable” error by following these practices:

• Avoid legacy sharing restrictions: Use supported collaboration features, such as OneDrive or SharePoint co-authoring, where suitable.

• Save VBA workbooks in the correct format: Use .xlsm or .xlsb when you need to retain VBA code.

• Keep a backup: Store a separate copy before changing workbook settings or repairing a file.

• Protect VBA projects carefully: Keep passwords in a secure place and make sure authorized users can access them.

• Use trusted files: Check files received through email or downloaded from the internet before enabling editing or running macros.

• Keep Excel updated: Install supported updates to reduce compatibility and software issues.

• Use security settings carefully: Enable programmatic access to VBA projects only when your task requires it.

These steps can help protect your code and make future troubleshooting easier.

Bottom Line

The “Excel VBA Project Is Unviewable” error does not always mean your VBA code is missing. It may be caused by workbook sharing restrictions, project protection, file access settings, or damage to the workbook.

Start by checking legacy sharing settings and whether the VBA project is password-protected. Then review file restrictions, confirm that the workbook uses a macro-enabled format, and try Open and Repair if necessary.

If the project is password-protected, you may need the correct password or an authorized recovery method. If you have forgotten the password for a workbook you own, a suitable VBA password recovery tool may be worth considering. If the code has already been removed or the project is badly damaged, you may need an earlier backup.

Work through the methods carefully and keep a backup of the original workbook before making changes.