How do I work with the "dialogs" I can insert as worksheet tabs?
I right-clicked on the tabs at the bottom of the worksheet to create a new
tab. One of the choices it offered me was "MS Excel 5.0 Dialog." When I
selected this, it came up with a worksheet that looks like a visual basic
work area where I can create whatever I want. It would be great if I could
use this function to create a checklist. I run a large number of projects at
one time. If I could click on the project name, and have this checklist come
up, it would be cool. I can create the checklist, then have it show up by
clicking the "Run Dialogue" button in the tool bar, but I don't know how to
have Excel run the dialog automatically when the tab is selected. Also don't
know how to go to individual versions of this checklist from another cell.
There is ver little help that I can find on the "dialog" subject.
|