repeating a macro

  • Thread starter Thread starter tylermdsm
  • Start date Start date
T

tylermdsm

I want a macro to repeat every 45 seconds in a shared workbook...the 5 minute
auto refresh just won't cut it as information changes fast than that.
 
Where does the 5 minute auto refresh originate?

Excel has no "autorefresh" except for External Data and it can be set to 1
minute which is pretty close to 45 seconds.

But...............to answer your question, see Chip Pearson's site for OnTime
method.

http://www.cpearson.com/excel/OnTime.aspx


Gord Dibben MS Excel MVP
 

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

repeating macro 2
Loop in Excel 1
Access Form Refresh 1
Dynamic Excel data into locked Word form 0
Macro for a one time triggered copy of cell value 8
i need to find the exact location of macro to paste in the existing macro need to get the out put co 0
repeat list 5 times 5
How do I pause a macro? 4

Back
Top