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.

Was this article helpful?

0 0
Black Jack Tactics Conquering The Game In Casinos

Black Jack Tactics Conquering The Game In Casinos

So, you want to learn how to play Blackjack. Youre in good hands. There is no better ship to chart those learning waters than the one youre riding on right now.

Get My Free Ebook

Post a comment