ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Adding a webBrowser object dynamically to a sheet (https://www.excelbanter.com/excel-programming/273521-adding-webbrowser-object-dynamically-sheet.html)

kena

Adding a webBrowser object dynamically to a sheet
 
I have created a macro that adds a webBrowser activex
object to a sheet dynamically.
ie:
ActiveSheet.OLEObjects.Add
(ClassType:="Shell.Explorer.2", Link:=False, _
DisplayAsIcon:=False, Left:=6, Top:=510.75,
Width:=3033.75, Height:= _
91.5).Select

Problem is: When I tell that object to navigate to a link
it does not redraw on the sheet. If I select it in "design
mode" then cut and paste it then will redraw. Wondering if
anyone has seen this as a bug and/or if there is a work
around for it.

Thanks in advance,
Ken


All times are GMT +1. The time now is 05:21 PM.

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