Microsoft Office Tutorials and References
In Depth Information
A Note on Macro Security
NOTE: You can select any keyboard key as the shortcut key—even one that’s already been
assigned to an existing Excel action (e.g., C, which in combination with Ctrl serves as the
standard Copy shortcut key). But don’t worry—if you assign such a key to the macro, the macro
will only play its shortcut role in that particular workbook. Ctrl+C will continue to work as Copy
on other workbooks. Ctrl+E and Ctrl+J are unassigned, and thus available without having to
“borrow” from an existing shortcut. You can also supplement a shortcut with the Shift key—for
example, you can assign Ctrl+Shift+W to a macro.
A Note on Macro Security
You often hear about Internet viruses that infiltrate your computer from a variety of
sources. Files containing macros are often prime suspects as virus bearers, so Excel
allows you to decide what kind of defense you want mount against these potentially
unwanted intruders.
Excel’s anti-macro-virus defense system is headquartered in what’s called the Trust
Center , which you can visit by clicking File Options Trust Center. Once you get there,
click the Trust Center Settings… button and then Macro Settings. You’ll see the options
shown in Figure 11–21.
Figure 11–21. Where to modify macro acceptance settings
Search JabSto ::

Custom Search