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
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