question on button event
 

I have an embedded word document on a worksheet
as an icon. Is it possible to have the embedded document
open up by using a button rather then the embedded
document? If so, can anyone assist in how it would be
accomplished as I am struggling.
Any assistance is appreciated and thanks in advance to
anyone who responds.
*** John

question on button event
 

Hi John:

Something like:

ActiveSheet.OLEObjects("Object 1").Activate

Regards,

Vasant.

"JohnE" wrote in message
...
I have an embedded word document on a worksheet
as an icon. Is it possible to have the embedded document
open up by using a button rather then the embedded
document? If so, can anyone assist in how it would be
accomplished as I am struggling.
Any assistance is appreciated and thanks in advance to
anyone who responds.
*** John

question on button event
 

Vasant, thanks. It worked.



-----Original Message-----
Hi John:

Something like:

ActiveSheet.OLEObjects("Object 1").Activate

Regards,

Vasant.

"JohnE" wrote in
message
...
I have an embedded word document on a worksheet
as an icon. Is it possible to have the embedded
document
open up by using a button rather then the embedded
document? If so, can anyone assist in how it would be
accomplished as I am struggling.
Any assistance is appreciated and thanks in advance to
anyone who responds.
*** John


.