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

Chapter 8. Customization, Macro, and VBA Annoyances

Chapter 8. Customization, Macro, and VBA Annoyances

The Excel interface can sometimes drive you a little nutty. There's the "adaptive" menu system in Excel 2002 (thankfully turned off by default in Excel 2003) that guesses (usually incorrectly) what menu options you want; silly limits in the filesystem; and dialog boxes that have so many tabs, checkboxes, and fields that some third-party developers make good money creating substitutes.

Ironing out these wrinkles—putting a toolbar button where you want it, or keeping snoops out of your files—is easy once you know a few insider moves. In this chapter, you'll learn how to customize the interface, secure your data, undo changes you made in the distant past, and create macros to automate those mind- and finger-numbing repetitive tasks. You'll also write a little Visual Basic for Applications (VBA) code to really rework and expand Excel's capabilities.


PREVIEW

                                                                          

Not a subscriber?

Start A Free Trial


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