Write, Bureaucrats, Administrators
2,725
edits
(Created page with "== Overview == If you ever get '''Unreadable Content in Startup.xlsm''', it most likely is due to have Visual Basic for Application not installed. == How to install VBA == [...") |
|||
Line 2: | Line 2: | ||
If you ever get '''Unreadable Content in Startup.xlsm''', it most likely is due to have Visual Basic for Application not installed. | If you ever get '''Unreadable Content in Startup.xlsm''', it most likely is due to have Visual Basic for Application not installed. | ||
== How to | == How to confirm if Microsoft Visual Basic for Application is installed == | ||
[[File:VBA installation.png|300px|thumb|right|]] | [[File:VBA installation.png|300px|thumb|right|]] | ||
[[File:VBA installation2.png|300px|thumb|right|]] | [[File:VBA installation2.png|300px|thumb|right|]] | ||
To confirm if Microsoft Visual Basic for Application is installed, follow these steps. | |||
#Start '''Excel''' | #Start '''Excel''' | ||
# Go to '''File \ Options''' | # Go to '''File \ Options''' | ||
# Select ''' | # Select '''Customize Ribbon''' | ||
# Tick the '''Developer ribbon''' | # Tick the '''Developer ribbon''' | ||
# Click ''' | # Click '''OK''' to close the options dialogue | ||
# Select the '''Developer tab''' | # Select the '''Developer tab''' | ||
# Confirm | # Confirm if the Microsoft Visual Basic and Macros buttons are both greyed out. | ||
If the Visual Basic button is greyed out, | If the Visual Basic button is greyed out, Microsoft Visual Basic for application is not installed. You will need to repair/reinstall/modify Microsoft Office to include it as per the images shown. | ||
<br clear=all /> | <br clear=all /> | ||
== Related Topics == | == Related Topics == |