Hi,

I used to have a workbook that my colleagues used, and now I converted it to
an add-in. I kept all the sub names, but renamed to the toolbar that calls
them. Now when my colleagues use both the add-in and the old workbook (not
that they should) the new menu calls subs from the old workbook. Is the a
way to say "use subs from ThisWorkbook"?

(I could always renames all the subs, but that's a bit of a pain).

Thanks,

Bura

Prefix the call will the name of the work book if you have a sub called
Test() in both open workbooks then:-

Call Book1!Test
Call Book2!Test

If they are in the different modules try

Call Book1!Module1.Test
Call Book1!Module2.Test

Cheers
Nigel

"Bura Tino" wrote in message
news:41ohc.2841$gO3.242791@attbi_s51...
Hi,

I used to have a workbook that my colleagues used, and now I converted it
to
an add-in. I kept all the sub names, but renamed to the toolbar that calls
them. Now when my colleagues use both the add-in and the old workbook (not
that they should) the new menu calls subs from the old workbook. Is the a
way to say "use subs from ThisWorkbook"?

(I could always renames all the subs, but that's a bit of a pain).

Thanks,

Bura

"Nigel" wrote in message
...
Prefix the call will the name of the work book if you have a sub called
Test() in both open workbooks then:-

Call Book1!Test
Call Book2!Test

The problem with this is that I'm developing the adding as an regular XLS
file (MyAddin.xls) and then saving it as an add-in (MyAddin.xla). I'm
guessing that would break the links you are suggesting.

If they are in the different modules try

Call Book1!Module1.Test
Call Book1!Module2.Test

Cheers
Nigel

"Bura Tino" wrote in message
news:41ohc.2841$gO3.242791@attbi_s51...
Hi,

I used to have a workbook that my colleagues used, and now I converted
it
to
an add-in. I kept all the sub names, but renamed to the toolbar that
calls
them. Now when my colleagues use both the add-in and the old workbook
(not
that they should) the new menu calls subs from the old workbook. Is the
a
way to say "use subs from ThisWorkbook"?

(I could always renames all the subs, but that's a bit of a pain).

Thanks,

Bura