Find Missing Shared Features and VBA in Office 2019 Click-to-Run
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.

- 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.
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.
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.
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.
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.
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.
Review and redeploy the Click-to-Run configuration if VBA was excluded
Use this approach when VBA is genuinely unavailable and the Office deployment configuration disabled it.
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.

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.




