macro on time
 

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.

macro on time
 

public bStop as Boolean
sub starttimer()
do until bStop

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

loop



"Enyaw" wrote:

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.