View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Nigel[_8_] Nigel[_8_] is offline
external usenet poster
 
Posts: 172
Default Qualifying sub names

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