View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Paul Moles Paul Moles is offline
external usenet poster
 
Posts: 34
Default macro to recalculate every 10 seconds

I am trying to use an Excel worksheet as a backdrop to a rolling Powerpoint
presentation. Their is no human intervention with the sheet or the
presentation once it is running.

I need a macro to recalcualate the sheet every few seconds or at least once
a minute to keep the presentation updated.

The links all work, (Excel highlighted cells, Copy, Powerpoint, Paste
special link) it is just the sheet update I need.

The sheet will be running in the background and the macro could be manually
started or an autorun when the workbook is opened.

Many Thanks

Paul Moles