View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Metallo[_3_] Metallo[_3_] is offline
external usenet poster
 
Posts: 39
Default Macro - Doesn't work in dedicate module

Hi,

I made a macro related to a WB that in this example we can call "WB A".

Then, I had another WB, that here we call "WB B" with the same format as WB A, therefore I thought it was a good idea to apply the same macro as WB A to give a different formatting.

I opened WB A and WB B, copied the macro from the Module of WB A, expanded WB B, inserted a Module and copied the code.
Tried, it works!

Where's the issue?
The issue is that when I open WB B and run the macro, in addition to the initial OK to enable the macro, it asks to enable the macros of WB A as well.
To sum up, if I look into the project part on VB, I can see the two WBs, each of them has got his own module to operate the macro, but WB B needs WB A to run it.

Where am I wrong?

Thanks for your help
Alex