View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Anya[_3_] Anya[_3_] is offline
external usenet poster
 
Posts: 2
Default How do I make a button appear when the custom Add-in is selected?

Hi, I've created an Add-in by writing VBA code in an Excel XP workbook and
then saving it as and .xla file. This is my first time creating an Add-in and
I see my Add-in in the Tools - Add-Ins menu so that's exciting :)
Now I'd like to add a button to the Tool bar and have that button appear
whenever myAddIn is enabled. And then I'd like my code (which is in my
Add-in) to run when the user clicks this new button. Could someone help
please? I see few similar questions here but not one that would tell me
exaclty how to do that.

Thank you.