Add In - How to start and use it
 

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

Add In - How to start and use it
 

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)

"Bimal" wrote in message
...
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

Add In - How to start and use it
 

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

(Bimal) wrote in message m...
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