Office Installation Errors

Find Missing Shared Features and VBA in Office 2019 Click-to-Run

Ayan MasoodAyan Masood Nov 13, 2026 869 views

Question details

The user needs to locate or enable Office Shared Features, particularly Visual Basic for Applications, in an Office 2019 Click-to-Run installation.

Find Missing Shared Features and VBA in Office 2019 Click-to-Run
Product
Microsoft Office 2019 Click-to-Run
Device & OS
not provided
Scenario
Checking the installed Office components and determining whether VBA can be added through installation settings.
Observed behavior
The Click-to-Run installation does not expose the MSI-style Office Shared Features tree, so the user cannot locate VBA through that interface.
Before you start

Open an installed Office application and check File > Account for the product name and installation information. If your organization manages Office, ask its administrator for the deployment configuration before changing installed components.

Solution 1Recommended

Confirm the installation type and check whether VBA is already available

Use this check first: a missing Shared Features menu does not necessarily mean VBA is missing.

Office 2019 uses Click-to-Run rather than the MSI installation model. Its installation settings do not provide the same component-selection tree found in older MSI-based Office versions.

1
Check the Office account page

Open Word or Excel and select File > Account. The presence of Update Options indicates a Click-to-Run installation. On managed installations, update controls may be hidden, so their absence alone does not prove that Office uses MSI.

2
Test access to the VBA editor

In Word or Excel, press Alt+F11 to open the Visual Basic Editor. Alternatively, enable Developer through File > Options > Customize Ribbon, select the Developer checkbox, and then choose Developer > Visual Basic.

3
Distinguish missing VBA from blocked macros

If the editor opens but macros cannot run, go to File > Options > Trust Center > Trust Center Settings > Macro Settings to inspect the restrictions. Do not enable all macros as an installation workaround; organization policy or the document's security status may be responsible.

No Shared Features tree is expected: The absence of an MSI-style Office Shared Features entry is normal for Click-to-Run and is not, by itself, evidence of an incomplete installation.
Free Microsoft Office alternative

Use WPS Office for Everyday Documents While Resolving Office Installation Issues

WPS Office is a free, lightweight alternative for everyday document, spreadsheet, and presentation work. Its familiar interface and Microsoft Office format compatibility make migration straightforward, but it does not repair Office 2019 Click-to-Run or restore Microsoft VBA components.

Continue everyday editing while an administrator reviews the Office installation.Open and edit Microsoft Office formats including .docx, .xlsx, and .pptx.Use a familiar ribbon-style interface to simplify switching from Microsoft Office.Get core document, spreadsheet, and presentation tools in a lightweight suite.
microsoft office alternative - wps office

Frequently Asked Questions

Why can't I find Office Shared Features under Programs and Features?

Office 2019 Click-to-Run does not offer the MSI-style feature-selection tree. Check VBA directly in Word or Excel with Alt+F11; if it was disabled during deployment, an administrator must review the Click-to-Run configuration.

Does a missing Update Options button mean I have an MSI installation?

Not necessarily. Go to File > Account to check the product information. Update Options indicates Click-to-Run when shown, but administrators can hide update controls. Office 2019 uses Click-to-Run, so confirm managed deployment details with your administrator.

Can I replace Office 2019 Click-to-Run with Office 2019 MSI?

No. Office 2019 does not have an MSI installation option. Do not add components from older MSI-based Office releases to reproduce the Shared Features menu; review the existing Click-to-Run deployment instead.

Is VBA missing if the Developer tab is hidden?

No. The Developer tab is often hidden by default. In Word or Excel, select File > Options > Customize Ribbon and check Developer. Then select Developer > Visual Basic, or press Alt+F11 directly.

Will WPS Office fix my Office 2019 VBA installation?

No. WPS Office is an alternative for document, spreadsheet, and presentation work, not a repair tool for Microsoft Office. If you depend on VBA macros, verify support for your specific WPS edition and test the files before switching.