Vba coding

Last Edited By Krjb Donovan
Last Updated: Mar 05, 2014 10:01 PM GMT

Question

Using 2007 I have a placed a button in a spreadsheet. I want to click on the button and upon the click I would like the following webpage to open. [1] I am unsure of how to approach this situation. The button has the following code already attached:

Private Sub CommandButton13_Click()

End Sub

Answer

Try code like this:


Private Sub CommandButton13_Click() ThisWorkbook.FollowHyperlink _

 Address:="http://amt-web01/AmTrustNet/Call_Center/Help_Desk_Manual/TermServ_Issues.asp", _
 NewWindow:=True

End Sub

Advertisement

©2024 eLuminary LLC. All rights reserved.