Posted to microsoft.public.excel.programming
|
|
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
|