View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
micah micah is offline
external usenet poster
 
Posts: 15
Default macro to scroll the worksheet and continue to run macro in backgro

I would like to display 20 rows of info, pause 20 secs, scroll 20 more until
I get to the end of the data.

I got it working, but only could stop the macro by using 'esc' key which
will throw off users when they get the stop or debug screens.

I tried to show a form with a command button, but that made the macro stop
until the form was unloaded.

I am trying to replicate the presentation mode of powerpoint, but use the
power of excel to check time functions and notify the users when a time has
passed as related to current time.