launch an embedded spreadsheet object

A

AlbertYWang

For an excel spreadsheet(objectname1) embedded as an OLE object, the
following code opens the embedded spreadsheet.

ActiveSheet.Shapes("objectname1").Select
Selection.Verb Verb:=xlPrimary

However, it is not visible because of other VBA forms being in the way.

Is it possible to launch this in a separate application window?

Albert Wang
 

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

Printing Embedded Word Document 0
Need Help with Run-time error 5
forcing specific sheet opening upon launch of .xlsx file 4
better way to copy data from an embedded html box 8
How can I programatically change the caption on a button? 3
Opening a Word Document from Excel - ??Stumped?? 1
Interactive web browser object embedded in an Excel print 0
Control of an OLE object (ppt) 1

Top