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

Prgrammatically added OLE Listbox, now cannot select from it 9
Putting 2 command buttons into 1 cell 2
Problem Populating a ComboBox 3
Textbox form to Textbox in worksheet 4
SHDOCVW in Worksheet 0
ActiveX Properties missing from menu 2
attach userform to button 0
Macro to add button w/code to new worksheet 2

Top