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 username and password options for securing financial functions

When working with customers to calculate payment information, it is often necessary to change loan parameters to meet customer needs. Although making these modifications is important, you may want to limit the users who have the ability to make these changes.

In this recipe, you will add a button to change the interest rates for a loan, which will ask you for a username and password before allowing the change to be made.

Getting ready

This recipe will begin with an existing worksheet that has information entered for calculating loan payment. The interest rate is in cell B8:

Getting ready

How to ...

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