macro on time

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

 

[Patrick Molloy]

public bStop as Boolean
sub starttimer()
do until bStop

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

loop