Running VBA from a HYPERLINK()

by

To run the function only on a click you can try entering as a subaddress:

=HYPERLINK("#generateEmail(H2, I2, M2)", "Generate Email")

and then add an extra line in the code to return the current address:

Function generateEmail(name, manager, cc)

Set generateEmail = Selection
'Paste Outlook Code Here 

End Function

Note this method does not get executed on the main vba thread so to test you can insert statements in the code instead of stepping through, eg:

Range("A10:C10") = Array(name, manager, cc)

More Related Contents:

  1. excel hyperlink to nothing
  2. VBA to open Excel hyperlink does not work when hyperlink generated with a formula
  3. delete Autofilter Field resullt using the header Name
  4. Somehow it’s not copying [closed]
  5. VBA macro that search for file in multiple subfolders
  6. So, I have 6 “master” files to then divide into 40 separate files
  7. Getting ScriptControl to work with Excel 2010 x64
  8. Count and Highlight keywords within phrases
  9. Transpose a range in VBA
  10. Protecting cells in Excel but allow these to be modified by VBA script
  11. Saving excel worksheet to CSV files with filename+worksheet name using VB [duplicate]
  12. Detect merged cells in VBA Excel with MergeArea
  13. Using VBA code, how to export Excel worksheets as image in Excel 2003?
  14. Parse HTML content in VBA
  15. How to add a DocumentProperty to CustomDocumentProperties in Excel?
  16. How do I name a spreadsheet automatically, by referencing two cells?
  17. Excel VBA Delete Rows
  18. VBA EXCEL To Prompt User Response to Select Folder and Return the Path as String Variable [duplicate]
  19. Should I turn .CutCopyMode back on before exiting my sub procedure?
  20. VBA: How to delete filtered rows in Excel?
  21. Determine whether user is adding or deleting rows
  22. How to use VBA SaveAs without closing calling workbook?
  23. Removing the password from a VBA project
  24. Removing special characters VBA Excel
  25. Count the number of rows in another sheet [duplicate]
  26. Getting Excel to refresh data on sheet from within VBA
  27. VBA Password Input with Cancel Function
  28. Finding first blank row, then writing to it
  29. Create hyperlink to another sheet
  30. VBA inheritance, analog of super

Leave a Comment