This <!post=Star Post,196505>Star Post<!/post> on the VBA board has some useful pointers for Excel VBA.

Search terms: "Making toolbar visible depending on text selected?", Class Module, EventHandler, Excel 97, Excel 2K, Excel 2000, Excel 2002.

Please note, that contrary to the thread title, this information is relevant to Excel 97 and up. I'm locking this thread - please post any replies to the original post on the VBA board above.