View Single Post
  #3   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,

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