I have a PowerPoint slide that has links to graphs in excel, I have managed to get the PowerPoint to update while running a slideshow. (So I can update excel without stopping the show)

But I cant figure out the code to make it (the PowerPoint presentation) the active window from Excel, as I am using a timed macro to refresh the data, so Excel ends up the active window and PowerPoint just stays on the same slide.

If I click on the running presentation it just keeps going and updates until the Excel macro runs again.

Any help would be great.