Write, Bureaucrats, Administrators
1,991
edits
Line 10: | Line 10: | ||
[[File:Repair_office_and_ensure_that_all_components_of_Office_are_installed_2.JPG|300px|thumb|right| Show the developer tab in ribbon]] | [[File:Repair_office_and_ensure_that_all_components_of_Office_are_installed_2.JPG|300px|thumb|right| Show the developer tab in ribbon]] | ||
[[File:Repair_office_and_ensure_that_all_components_of_Office_are_installed_3.JPG|300px|thumb|right| Confirm Microsoft Visual Basic is not greyed out]] | [[File:Repair_office_and_ensure_that_all_components_of_Office_are_installed_3.JPG|300px|thumb|right| Confirm Microsoft Visual Basic is not greyed out]] | ||
#Start Excel | |||
# Go to File \ Options | To identify that VBA is not fully installed, follow these steps. | ||
# Select customize ribbon | |||
# Tick the Developer ribbon | #Start '''Excel''' | ||
# Click ok to close the options dialogue | # Go to '''File \ Options''' | ||
# Select the Developer tab | # Select '''customize ribbon''' | ||
# Tick the '''Developer ribbon''' | |||
# Click '''ok''' to close the options dialogue | |||
# Select the '''Developer tab''' | |||
# 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. | ||