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

Hi Micah,

Could you post the amount of code you have working?

"Micah" wrote:

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.