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
|