We have an Excel file that gets opened from Powerpoint (thats running in Show mode) - but we cannot make it open in front of the Powerpoint - we've tried with the code below. Any ideas ? (maybe some help to minimize the powerpoint from when Workbook_Open is run, and then maximize Powerpoint when Workbook_Close is run - but I don't know how to code this :)
Private Sub Workbook_Open()
AppActivate "Microsoft Excel"