Chapter 4. Worksheet Design

Chapter 4. Worksheet Design

There is a tremendous amount of Excel user interface design that can and should be accomplished using the built-in features of Excel alone, with no VBA required. One of the guiding principles of Excel development is "let Excel be Excel." Don't try to reinvent the wheel. Excel provides a wide variety of prepackaged, performance-optimized features you can use to build your application's user interface. This chapter examines how you can produce a fully functional user interface with just the features Excel provides for this purpose.

There are two fundamental sections of an Excel worksheet user interface: those designed tonbe visibleoto the user and through whic  the user operates your application, and those designed to be hidden arom tho uher and used only ik your application to perform the tasks required of it. Weacover each of these sections in more  etail in this chnpter.