Delay/Slow a Macro In Excel 2003

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have a spreadsheet that is populated from an outside source. I also have a
macro that formats and prints this document for me. However, when I print it
does not allow the entire spreadsheet to populate. How can I slow the print
part of the macro down to allow the rest of the spreadsheet to populate with
data?

Thanks for the help!
 
Kara,
This code seemed to work for me. This line is set to delay execution of the
"RunMacro" sub for seven seconds.

Application.OnTime Now + TimeValue("0.00.07"), "RunMacro"

HTH
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

MACRO - I think. 1
Stop Macro running when I save the workbook 1
Quick way for monthly linking of Excel sheets 0
How to apply a function to an entire column 1
Run Macro Upon Entering Data into Cell/s 3
repeatedly extract a field to create a new list in another file? 1
Macro Security 1
INDIRECT doesn't retain data from external worksheets 2

Back
Top