Creating the Data Worksheet

As an Excel application gets more complex, the associated menu gets more complex. Rather than store all data directly in code, it makes sense to use a worksheet. Recall that add-in worksheets are hidden from the user, so they are the perfect place to keep data for the add-in.

Open the SRXUtils.xls source workbook, delete all sheets but one, and name that sheet DataSheet. Fill in the sheet as shown in Figure 12-5. This sheet contains one row for each procedure (or utility) of the add-in (we will add more rows later in the book). The first row is for the ActivateSheet utility whose code shell we included earlier. We will add code shells for the other utilities a bit later. In later chapters, we will implement these utilities properly.

0 0

Post a comment