question on button event

J

JohnE

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
 
V

Vasant Nanavati

Hi John:

Something like:

ActiveSheet.OLEObjects("Object 1").Activate

Regards,

Vasant.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Embed the same Excel multiple times 0
ASK Field Formatting 1
List all tables, including document structure 0
Issue with ExportAsFixedFormat PDF (and solution) 2
Getting Radio Buttons to work, that are inserted via AutoText 0
embedded Word document 1
Select Embedded Documents 3
Page numbering with Merged Document and IF statements 1

Top