amy_goe
asked on
Open Ole Object with VBA in front of the Excel Window
I have an excel spreadsheet with a video that is embeded as an OleObject. I have code set on a button to open/activate the video. The code works fine except that sometimes the video opens in front of the excel window (as I want it to) and sometimes it opens behind the window. Is there code I can use to specify that it should open in front?
The code I have now is just:
Private Sub CommandButton2_Click()
Me.OLEObjects("Video").Act ivate
End Sub
The code I have now is just:
Private Sub CommandButton2_Click()
Me.OLEObjects("Video").Act
End Sub
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER