Adding a webBrowser object dynamically to a sheet

K

kena

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
 

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

Creating a button and assigning macro 1
trying to put a check box in each shell with vba 3
Adding a Controls Listbox via VBA 2
OLEobject on the sheet 1
Removing Command Button 1
OLEObjects clickable? 1
Adding a Control programatically 9
Combobox in each wks 1

Top