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

Macro - Doesn't work in dedicate module
 

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

--

Vasant

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

Macro - Doesn't work in dedicate module
 

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

"Vasant Nanavati" wrote:

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

--

Vasant

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