You can select another application's objects that you want available in your code by setting a reference to that application's object library.

Add an object

From the Developer tab, open a Visual Basic project window. See Make the Developer tab visible below if it's not open.

  1. On the Tools menu, click References.

    Preferences selection on Tools menu

  2. Under Available References, select the check box for the object library that you want available in your Visual Basic project.

    Available references dialog

    Note: You should clear the check box for the object libraries that you do not want in your Visual Basic project to reduce the time it takes to compile.

  3. To set the order in which the object libraries are accessed, under Available References, select the object library, and then click the Priority buttons to move the object library up or down.

  4. To add other object libraries to Available References, click Browse, and then find the object library that you want.

  5. Browse for an object

  1. On the top bar, select Excel > Preferences > Ribbon & Toolbar.

  2. Under Customize the Ribbon, select Main Tabs and then check Developer.

  3. Click Save and then close Excel Preferences.

Need more help?

Expand your skills
Explore Training
Get new features first
Join Microsoft Office Insiders

Was this information helpful?

What affected your experience?

Thank you for your feedback!

×