Home |
Search |
Today's Posts |
#3
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Yes, it was the module name.
I had thought that sequence of code was working ok. Perhaps it was not. Irrespective of that, your suggestion appears to be working. I will test further. Why might this work rather than a full "path" to the routine, please? Regards and thanks. "JE McGimpsey" wrote in message ... I'm assuming that InDirect_Menu_Routines is your module name. In that case, try: Application.Run "BofQUtilities.xla!VlnSearchAndProtect" In article , "Stuart" wrote: In the following code sequence: Set wkbk = ActiveWorkbook Application.ScreenUpdating = False Application.Calculation = xlCalculationManual Call InsertVlnCollectionFormulae(wkbk) Call TransferToSummarySheet(wkbk) Application.Run _ "BofQUtilities.xla!InDirect_Menu_Routines.VlnSearc hAndProtect" Application.Calculation = xlCalculationAutomatic the Application.Run statement is not executing. When I set breakpoints, the code stepped straight through the line. Can anyone help, please? --- Outgoing mail is certified Virus Free. Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.614 / Virus Database: 393 - Release Date: 05/03/2004 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Code execution has been interrupted | Excel Discussion (Misc queries) | |||
Help - VBA Code execution in Excel | New Users to Excel | |||
Code Execution has been interupted | Excel Discussion (Misc queries) | |||
code execution has been interrupted | Excel Discussion (Misc queries) | |||
VBA: Pausing Code Execution | Excel Programming |