O'Reilly logo

Excel 2010 Financials Cookbook by Andre Odnoha

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

Adding financial tools to the Excel ribbon

Many of the user-defined shortcuts and user forms that are created to enhance Excel are accessible through various methods. To increase the effectiveness and efficiency of the add-ins, they need to be readily accessible.

In this recipe, you will learn how to add the enhancements you create to the Excel ribbon. For this recipe, we will add the loan calculator tool created in Chapter 3, Moving Beyond the Grid—Financial Data Via an Interface to the Excel ribbon.

How to do it...

We will begin by opening the Excel sheet that contains the loan calculator:

  1. Press Alt + F11 on your keyboard within the worksheet to verify the existence of the loan calculator code:
  2. Next, from the Excel toolbar, choose the office button ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required