During installation, select the workload to include Visual Basic support.
(Adjust path to your version). Then restart Office. download microsoft visual basic for applications core
Sometimes the files exist, but the registry linkage is broken. Open Command Prompt as Administrator and run: During installation, select the workload to include Visual