macro on time

  • Thread starter Thread starter Enyaw
  • Start date Start date
E

Enyaw

Is there a way of getting a macro to run and when finished do not start again
for another minute . The macro will move onto the next sheet and create a
sort of slideshow updating the information from other worksheets.
 
public bStop as Boolean
sub starttimer()
do until bStop

application.ontime now()+Timevalue("00:01:00"),"MySup"

loop
 
Back
Top