View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Joyce Joyce is offline
external usenet poster
 
Posts: 106
Default Return to Excel from Word Object

I have an embedded Word object (a form that works better in Word than Excel).

I inserted a text box with the instruction to click it to activate the Word
form:

Sub WordForm()

Set obj = Sheets("sheet1").OLEObjects("Object 21")
obj.Activate

End Sub

My problem is returning the focus to the Excel worksheet when the user has
finished filling in the form. I'm sure it's pretty simple, but I can't seem
to get anything to work.

Thanks.