Add In - How to start and use it

  • Thread starter Thread starter Bimal
  • Start date Start date
B

Bimal

I have created a macro which adds a command in the shortcut menu if that
workbook is activated. This works fine. But when I save the same as addin it
does not work. It also does not add the command at the shotrcut menu.
I have tried with on install but in vain.

Am I missing somthing obvious?

Regards,
Bimal
 
Bimal,

Can we see the code?

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)
 
Hi
The AddIn is never the active workbook. If you want to refer to active
workbook objects in your Add In code (sheets etc) use
ActiveWorkbook.Object. If you want to refer to objects in the AddIn
itself use ThisWorkbook.Object.

regards
Paul
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Add-In Menu Handling 3
Problem in adding macro to ribbon through Add-in 7
Cannot remove custom commands from 2007 add-ins tab 1
CommandBar and Controls (how to create separate "Sets" of Controls) 4
Missing Save As Add-in option 1
Macro shortcuts are running macros in different open workbook 3
COM addin won't connect when workbook opened via another workbookfrom another instance 3
Running a excel macro from VB6 2

Back
Top