LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
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.
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
excel object linked to word will not add sums in word Robin Excel Discussion (Misc queries) 0 March 31st 09 11:10 PM
Insert Excel Object in MS Word Scott King[_2_] Excel Programming 0 July 23rd 07 11:32 PM
PLS HELP! Excel imbedded object in Word dee Excel Discussion (Misc queries) 0 March 14th 07 01:21 PM
word object in excel daron tan Excel Programming 0 September 21st 05 10:27 AM
Return MS Word word counts in Excel? MLulofs Excel Programming 3 April 27th 04 05:25 PM


All times are GMT +1. The time now is 08:04 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"