Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#3
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How does a module of VB work in a Worksheet? | Excel Worksheet Functions | |||
Which macro module | Excel Discussion (Misc queries) | |||
macro to standard module | Excel Discussion (Misc queries) | |||
When open an old xls, an new macro is in a new module. | Excel Programming | |||
protect module and work in activeworkbook | Excel Programming |