Write, Bureaucrats, Administrators
1,991
edits
Line 5: | Line 5: | ||
[[File:Repair_office_and_ensure_that_all_components_of_Office_are_installed_1.JPG|300px|thumb|right|Error: Removed VBA]] | [[File:Repair_office_and_ensure_that_all_components_of_Office_are_installed_1.JPG|300px|thumb|right|Error: Removed VBA]] | ||
< | <br clear=all /> | ||
== How to identify that VBA is not fully installed == | == How to identify that VBA is not fully installed == | ||
[[File:Repair_office_and_ensure_that_all_components_of_Office_are_installed_2.JPG|300px|thumb|right|Error: Removed VBA]] | |||
[[File:Repair_office_and_ensure_that_all_components_of_Office_are_installed_3.JPG|300px|thumb|right|Error: Removed VBA]] | |||
Start Excel | |||
# Go to File \ Options | # Go to File \ Options | ||
# Select customize ribbon | # Select customize ribbon | ||
Line 17: | Line 18: | ||
# Confirm that the Microsoft Visual Basic and Macros buttons are both greyed out. | # Confirm that the Microsoft Visual Basic and Macros buttons are both greyed out. | ||
If they are, that is a an indication that VBA was not installed as part of Office. You will need to repair office and ensure all components get installed. | If they are, that is a an indication that VBA was not installed as part of Office. You will need to repair office and ensure all components get installed. | ||
<br clear=all /> | |||
== How to reinstall office == | == How to reinstall office == | ||
If the previous solutions do not help resolve the problem, it may be worth considering reinstalling Microsoft Office. Please contact your IT Support provider. | If the previous solutions do not help resolve the problem, it may be worth considering reinstalling Microsoft Office. Please contact your IT Support provider. |