Home |
Search |
Today's Posts |
#2
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Good catch - I can reproduce it in xl2000 as well. I can't say why either.
-- Regards, Tom Ogilvy "Andy Pope" wrote in message ... Hi Tom, I can generate the problem and solution with two very simple macros, in the same workbook. Sub A MsgBox "Sub A" End Sub Sub B Application.Run "A()" End Sub If you remove the open and close brackets all works as expected. i.e. Sub B Application.Run "A" End Sub Trouble is I do not know why. Tom Ogilvy wrote: what fires the original macro? Is it tied to an event? I would put a msgbox in the original macro just before the run command and see if the original macro is running twice as well. -- Cheers Andy http://www.andypope.info |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
VBA macro runs fine, but freezes if I try to do ANYTHING else whileit runs | Setting up and Configuration of Excel | |||
Excel Macro runs fine, but freezes if I try to do ANYTHING else whileit's running | Setting up and Configuration of Excel | |||
Excel macro in 2007 runs extremely slow | Excel Discussion (Misc queries) | |||
How to change the macro called by an add in from older excel? | Excel Discussion (Misc queries) | |||
One macro runs then it auto runs another macro | Excel Discussion (Misc queries) |