Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
I have a macro (call it TheFinalPrintMacro) that calls two other macros:
(call them (LoadPicture) and (PrintLetter) The first macro (LoadPicture) changes out the image in Image1 on Sheet1, based upon the selection in a drop list. This macro works fine on its own. The second macro (PrintLetter) simply prints a portion of the the page (Sheet1) that contains, among other things, the image in the first. This macro works fine on its own. TheFinalPrintMacro simply consists of calling the other macros in order: Sub FinalPrintMacro LoadPicture PrintLetter EndSub The problem is that the letter is printing before the picture has been loaded and I DON'T KNOW WHY. I don't know if I need to have the system wait a couple of seconds or verify that it has completed the LoadPicture function before calling PrintLetter. Please help. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Advancing Timing | Excel Discussion (Misc queries) | |||
Timing Issue?? | Excel Programming | |||
Timing Chart | Charts and Charting in Excel | |||
VB timing question | Excel Programming | |||
Program timing | Excel Programming |