repeating a macro

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.
 
G

Gord Dibben

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
Hi All - How do i get my vba macro to refresh every minute? 2
Disable Macro Alert 2
How do I pause a macro? 4
Filters and subtotals 2
Eliminate macro warning when you open a workbook 1
Analysis ToolPaks VBA Fast Fourier Transform 3

Top