Hi, I am trying to combine two macros into one, the first opens the print requester and the second saves and clears the input form of the data that has just gone to print. Given that the print requester window is external to the sheet, does this have to complete before the second macro can run? if so, is there a 'wait until' function available so that the data sent to print has copied out of the sheet before it is cleared?
I need to open the print requester rather than send direct to default printer so I can select output to fax, but the time taken to select the printer driver and complete the external element is variable and the concern is that if the Complete Form macro runs too early, the data will be cleared before printing has completed and thus the faxed form would be empty of data
' PrintForCustomer Macro