Add a Reference To The Microsoft Office Object Library

Here are some steps to follow, to allow you to add a reference to the Microsoft Office Object Library from within Excel. Steps 1, 2 & 3 can be skipped via ALT+F11, but it’s handy to have the developer tab added for later on.

Depending on your version of Office, these steps or the names of the objects may differ slightly – Office 2010 is 14.0, Office 2012 is 15.0 etc

1: Firstly, add the Developer tab to Excel – Right-click anywhere in the ribbon & select ‘Customise The Ribbon’:


2: Put a check in the ‘Developer’ box & hit ‘OK’:


3: Switch to the Developer tab, and hit the Visual Basic shortcut:


4: Select Tools > References:


5: Scroll down to the required Library, add a check box, and hit ‘OK’


This entry was posted in MS Excel, VBA and tagged , , , , . Bookmark the permalink.

Leave a Reply