open hyperlink in new tab
hello everyone I am using excel 2003 and would like some vba code on opening several websites in new tabs for internet explorer. I have the following code.
Sub urltabs ()
const navopeninnewtab = &H800
set tabby = createobject ("internetexplorer.application")
tabby.visible = true
tabby.navigate "http://www.google.com"
tabby.navigate "http://www.yahoo.com", clng(navopeninnewtab)
tabby.navigate "http://www.msn.com", clng(navopeninnewtab
end sub
everything works great with this code but I want the user to be able to put the urls in cells rather than change them in the vba editor how can I accomplish this?
|