Page 118 - Microsoft Office Excel 2003 Programming Inside Out
P. 118

Microsoft Office Excel 2003 Programming Inside Out





























                             Figure 5-3.  Adding the Option Private Module line to a module’s declaration section hides all
                             procedures in a module from view.

                             To display the declarations section of a code module, you click the down arrow at the right
                             edge of the Procedure list box and click Declarations. When you do, a new section, delineated
                             by a line, will appear in your code module.
















             Chapter 5










                             You may then type the Option Private Module declaration in the proper section.


                92
             Part 2:  Visual Basic for Applications
   113   114   115   116   117   118   119   120   121   122   123