Macros attached to AutoShapes   

In an Excel workbook, AutoShapes with macros assigned to them, are used to 
navigate to various worksheets, and external Word documents (using 
hyperlinks).  Now I want to insert an AutoShape in a Word document and have 
it go to a specific worksheet in an Excel document.  How would this be done?

date: Wed, 8 Mar 2006 01:08:29 -0800   author:   Phil H

Re: Macros attached to AutoShapes   

Hi =?Utf-8?B?UGhpbCBI?=, 

> In an Excel workbook, AutoShapes with macros assigned to them, are used to 
> navigate to various worksheets, and external Word documents (using 
> hyperlinks).  Now I want to insert an AutoShape in a Word document and have 
> it go to a specific worksheet in an Excel document.  How would this be done?
>
Basically, it can't. Word doesn't directly support linking code to AutoShapes 
or graphics. Best you could do with Word would be to use document events, such 
as Window_BeforeDoubleClick to capture a double-click, figure out WHAT was 
double-clicked, and branch to the appropriate set of actions.

You might take a look at the Macrobutton field. You can insert an INLINE 
graphic as the "display text" so that you'd get the same basic effect as in 
Excel. (In order to turn an AutoShape into a static graphic that can be 
inline, copy it, then use Edit/Paste Special to paste it as a bitmap.)

Cindy Meister
INTER-Solutions, Switzerland
http://homepage.swissonline.ch/cindymeister (last update Jun 8 2004)
http://www.word.mvps.org

This reply is posted in the Newsgroup; please post any follow question or 
reply in the newsgroup and not by e-mail :-)

date: Wed, 08 Mar 2006 17:46:55 +0100   author:   Cindy M -WordMVP-