• Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint
Share this Page URL
Help

Chapter 5. Managing Your Money with a Budget > The Home Budget Calculator

The Home Budget Calculator

The Home Budget Calculator template, in the file Home Budget.xls, provides you with a convenient way to keep a budget. It automates some of the tasks, such as entering your paychecks and performing calculations of the totals. Let’s look at the parts of this template.

Macros and Excel Security

This is the first of several templates in this book that use macros. A macro is nothing more than some instructions, or code, that is a part of a workbook and helps it to perform its functions. Macros are powerful but have the potential for misuse. A malicious person could distribute a workbook containing a macro that would delete critical files or do other mischief on your system.

For this reason, Excel has a macro security feature that detects macros in workbooks you are opening and responds according to the security level you have set. To set your security level, select Tools, Macros, Security to display the Security dialog box. You’re offered three choices:

  • High— Only macros that are digitally signed by trusted sources will be enabled; all others will be disabled without warning. This setting is not recommended because the macros in this book’s templates are not signed and would be automatically disabled, causing some of the templates to function incorrectly.

  • Medium— Excel asks you to enable or disable macros each time you open a workbook that contains macros. This is the setting that I recommend. You can enable macros in the workbooks that come with this book as well as those from other known, safe sources, while disabling macros in workbooks from any questionable sources.

  • Low— Excel enables all macros without warning. This setting is not recommended, certainly not if you’re not running an up-to-date virus scan program.



PREVIEW

                                                                          

Not a subscriber?

Start A Free Trial


  
  • Creative Edge
  • Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint