Vba macro with hyperlink

Mariabruja

New Member
Joined
Nov 10, 2009
Messages
48
I have a button in a form with a macro that hyperlinks to a "Expense Report" file. If the operator select yes the file opens up and they are able to work on the file and save it; however, if the operator selects cancel on the dialog box and error message appears. If they click on the "x" to close the error dialog box it takes them back to the sheet where I made the macro, but if they press the debug button it takes them to the "Macro Expense Report"code section. Is there a better way to hyperlink to a file, since the particular form is going to have about 12 different hyperlinks, depending what the operator is going to do? Any suggestions would be appreciated! Thanks, MBruja

Using Excel 2007 and here is the code:
Private Sub Cmd_Click
'
' Johndoemonthlyexpensereport Macro
'

'
Range("A2").Select
Selection.Hyperlinks(1).Follow NewWindow: = False, AddHistory: =True
End Sub
 

Some videos you may like

Excel Facts

Easy bullets in Excel
If you have a numeric keypad, press Alt+7 on numeric keypad to type a bullet in Excel.

Watch MrExcel Video

Forum statistics

Threads
1,122,600
Messages
5,597,114
Members
414,125
Latest member
iQQ

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top