Difference between revisions of "Unreadable contents error when starting DirectDebitsLink"

Jump to navigation Jump to search
no edit summary
(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 install VBA ==
== 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 '''customize ribbon'''
# Select '''Customize Ribbon'''
# Tick the '''Developer ribbon'''
# Tick the '''Developer ribbon'''
# Click '''ok''' to close the options dialogue
# Click '''OK''' to close the options dialogue
# Select the '''Developer tab'''
# Select the '''Developer tab'''
# Confirm that the Microsoft Visual Basic and Macros buttons are both greyed out.  
# Confirm if the Microsoft Visual Basic and Macros buttons are both greyed out.  


If the Visual Basic button is greyed out, they haven’t got it installed. And need to repair/reinstall/modify office to include it as per the images shown.
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 ==
1,137

edits

Navigation menu