M
Michelle Bradley
Hi,
I need to be able to print an Excel spreadsheet with an embedded web browser
object. When I print, the spreadsheet is visible but the object is not
visible. The object is generated by an address entered into Google maps. I
am a total newbie however I usually can figure problems out given enough
time. This time I am stumped. This is to code that I am using. Any help
would be appreciated.
Thanks
Private Sub CommandButton1_Click()
ActiveSheet.Shapes("WebBrowser1").OLEFormat.Object.Object.Navigate2 _
"http://maps.google.com/maps?output=embed&z=8&f=q&source=s_q&hl=en&geocode=&q=2001+ellis+road,+32254"
End Sub
Private Sub WebBrowser1_StatusTextChange(ByVal Text As String)
End Sub
Private Sub Worksheet_SelectionChange(ByVal Target As Range)
End Sub
I need to be able to print an Excel spreadsheet with an embedded web browser
object. When I print, the spreadsheet is visible but the object is not
visible. The object is generated by an address entered into Google maps. I
am a total newbie however I usually can figure problems out given enough
time. This time I am stumped. This is to code that I am using. Any help
would be appreciated.
Thanks
Private Sub CommandButton1_Click()
ActiveSheet.Shapes("WebBrowser1").OLEFormat.Object.Object.Navigate2 _
"http://maps.google.com/maps?output=embed&z=8&f=q&source=s_q&hl=en&geocode=&q=2001+ellis+road,+32254"
End Sub
Private Sub WebBrowser1_StatusTextChange(ByVal Text As String)
End Sub
Private Sub Worksheet_SelectionChange(ByVal Target As Range)
End Sub