Macro - Doesn't work in dedicate module

[Guest]

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

 

[Vasant Nanavati]

Perhaps the macro makes specific references to WB A? If you post the macro
it would be easier to diagnose the problem.

--

Vasant

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.

 

[Guest]

Hi,

Hi solved the problem.
Although the module was included in the WB, I forgot to change the reference in the buttons I created.
Now it works perfectly.

Thank you
Alex