Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Macro execution limit
Hi,
I have the following situation. I have about 120 charts on a worksheet. Each chart is associated with its own macro (I have about 120 macros). All these macros are executed by one sub procedure when the execel worksheet is opened. The problem I have is that I receive and error after it tries to execute the 49th macro. Is there a limit to the amount of macros that can be executed? I have tried to break up the macro calls into 4 different sub procedures (See Below). This does not work either. eg. Sub RunMacros1() RunChartMacro1 RunChartMacro2 RunChartMacro3 RunChartMacro4 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Macro execution limit
What does the error say ?
Best wishes Harald "Benn" skrev i melding ... Hi, The problem I have is that I receive and error after it tries to execute the 49th macro. Is there a limit to the amount of macros that can be executed? |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Macro execution limit
it says just "400" in an error dialog
-----Original Message----- What does the error say ? Best wishes Harald "Benn" skrev i melding ... Hi, The problem I have is that I receive and error after it tries to execute the 49th macro. Is there a limit to the amount of macros that can be executed? . |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Macro execution limit
Not even a Debug button ?
Best wishes Harald "Benn" skrev i melding ... it says just "400" in an error dialog -----Original Message----- What does the error say ? Best wishes Harald "Benn" skrev i melding ... Hi, The problem I have is that I receive and error after it tries to execute the 49th macro. Is there a limit to the amount of macros that can be executed? . |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Macro Execution | Excel Discussion (Misc queries) | |||
Automatic execution of macro | Excel Programming | |||
Template Macro Execution | Excel Programming | |||
Triggering Macro Execution | Excel Programming | |||
automatic macro execution | Excel Programming |