ipbr21054
Well-known Member
- Joined
- Nov 16, 2010
- Messages
- 5,226
- Office Version
- 2007
- Platform
- Windows
Hi,
I have a msgbox where No closes it but i would like when Yes is clicked it will Call say the below to run it
can you advise the correct way to wright it please
I have a msgbox where No closes it but i would like when Yes is clicked it will Call say the below to run it
VBA Code:
Private Sub DHLBUTTON_Click()
ActiveWorkbook.FollowHyperlink Address:="http://www.dhl.co.uk/en/express/tracking.html", NewWindow:=True
End Sub
can you advise the correct way to wright it please