Microsoft Office Tutorials and References
In Depth Information
Enabling and examining macros
You can also use form controls and macros to create custom solutions for your business.
By adding controls such as text boxes, spin controls, and list boxes, you can design a
userfriendly interface for you and your colleagues to enter data quickly while minimizing errors.
In this chapter, you’ll open, run, create, and modify macros; create Quick Access Toolbar
buttons and shapes that you can use to run macros with a single mouse click; run a macro
when a workbook is opened; and add controls and set form properties for a UserForm.
PRACTICE FILES To complete the exercises in this chapter, you need the practice files
contained in the Chapter12 practice file folder. For more information, see “Download
the practice files” in this topic’s Introduction.
Enabling and examining macros
It’s possible for unscrupulous programmers to write viruses and other harmful programs by
using the Microsoft Visual Basic for Applications (VBA) programming language, so you need
to be sure that you don’t run macros from unknown sources. In addition to running
protective software such as Windows Defender, you can also change your Excel macro security
settings to control when macros can be run. After you’re sure a macro is safe, you can open
it in the Visual Basic Editor to examine its code.
Changing macro security settings
In versions of Excel prior to Excel 2007, you could define macro security levels to determine
which macros, if any, your workbooks would be allowed to run, but there was no workbook
type in which all macros were disallowed. Excel 2013 has several file types that you can use
to control whether a workbook will allow macros to be run. The following table summarizes
the macro-related file types.
Extension
Description
.xlsx
Regular Excel workbook; macros are disabled
.xlsm
Regular Excel workbook; macros are enabled
.xltx
Excel template workbook; macros are disabled
.xltm
Excel template workbook; macros are enabled
Search JabSto ::




Custom Search