Move focus away from Powerpoint in Show mode

@Bojerne -

what i understand from your question is.., you're opening an excel file from powerpoint show. when clicked, u want the excel to be in front of powerpoint show..,

i'd say:

Use Insert, Hyperlink, then point to the Excel workbook you want displayed. When you close Excel, you automatically return to the PowerPoint slide containing the hyperlink.

Thanks,
David

Hi David

Thank you for the fast response. I know how to open the excel from powerpoint :) - but when powerpoint is run in Show mode it tends to remain infornt/in forcus - so some of our users don't notice that Excel has been opened because it's opened "behind" the Powerpoint pres.

So I was hoping someone could help me with some code that can run in the excel event "Workbook_Open", that minimizes the powerpoint on and brings the excel workbook itself in focus.

Thank you
Michael

Below is the code as required by you

Private Sub Workbook_Open()
ActiveWindow.WindowState = xlMinimized
End Sub

Select allOpen in new window

But won't that code just minimize the excel ?

no it will minimize ppt

or you may try this:

Private Sub Workbook_Open()
PowerPoint.Application.WindowState = ppWindowMinimized
End Sub

Select allOpen in new window

you need to add reference of powerpoint before using above code.

I've just tested it, and it still opens in the background, but now with the Workbook minimized... :) See attached. I'm running Off 2010
Minimized.jpg

PowerPoint.Application.WindowState = ppWindowMinimized

also don't minimize the ppt and doesn't bring the xlsm in front  :) ?

Just removed an On error, and now I can see I'm getting an error when trying to run the line you suggested - but can't see why ? Please see attached
Open-error.jpg

Thank you for leading me in the right direction