Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
We have a VB client calling two Excel macros.The first macro got
parameters and the second none.They are getting called from the client in the same order,ie,macro with parameters first and the macro with no paramter next. The problem is that though the first macro gets executed the second doesnt.When I try to execute the macros from VB in debug mode,the second macro call always opens the VBA editor.I also tried calling a dummy macro without parameter first,the macro with paramter next followed by a macro with/without parameters.The first and second macro get executed,but,the third(last) macro doesnt get called as usual, and I presume again that the second macro having parameters is creating a situation. Also I noticed that when I open from Excel Tools-Macro-Macros I do not see any Parameterized macros in the macro list! Any help would be highly appreciated. Thank you Sundar CIStems Software LTD,Jaipur. [note: iam currently using MS office 2000 on win 2k prof] |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Preventing users from changing macros | Excel Discussion (Misc queries) | |||
Excel 2007 macros - how to merge 5 macros together into one | Excel Discussion (Misc queries) | |||
Macros warning always shows up, even if all macros removed | Excel Discussion (Misc queries) | |||
Training: More on how to use macros in Excel: Recording Macros | Excel Worksheet Functions | |||
List the Macros that can be executed from Tools-Macros | Excel Programming |