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
 
Back
Top