The main function of this application is controlled by the Mapsheet worksheet. The map on that worksheet is actually a collection of objects. It was originally defined in a package like Arcview, and then imported into Powerpoint and in turn Excel. During that process that map was ungrouped so that it was composed of individual objects for each state and each state was manipulated to allow the functionality required. In particular
| • | the state object was right clicked on (as in the case of Montana below) and given a name in the spreadsheet range name box as illustrated in the red square below |
| • | A worksheet page was defined within the workbook named with just the same spelling as the state name |
| • | The map object for each state that was to be active (in terms of transferring to a web page) was right clicked on and associated with the macro called MapSheetGotoState which uses the range name for the item clicked on to determine the sheet that will be displayed (thus the requirement that the sheet name and the range name be the same). |
Note the state object Idaho was not associated with a state, nor was a worksheet added for it since it was not an active part of the model.
| • | In turn the worksheet with the name of the state was set up to have appropriate content. |