ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   launch an embedded spreadsheet object (https://www.excelbanter.com/excel-programming/352657-launch-embedded-spreadsheet-object.html)

AlbertYWang

launch an embedded spreadsheet object
 
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



All times are GMT +1. The time now is 12:27 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com