Excel Tips

Create Custom Macro Workbook

1. Create new workbook for custom macros.
2. Save workbook in a folder with no other items.
3. Hide workbook:
   Window/Hide
4. Configure Custom Macro Workbook to automatically open by placing folder name in:
   Excel/Tools/Options/General/At startup, open all files in:

Dynamic Hyperlink Formula

View Web Page	Query String Value
=HYPERLINK("http://www.mydomain.com/mypage.htm?name="&B2, "View Web Page")	MyValue1
=HYPERLINK("http://www.mydomain.com/mypage.htm?name="&B3, "View Web Page")	MyValue2
=HYPERLINK("http://www.mydomain.com/mypage.htm?name="&B4, "View Web Page")	MyValue3

Macro to Convert Text Hyperlink to Working Hyperlink

Sub HyperLinkConvert()

       ' From Microsoft: http://support.microsoft.com/kb/271856

       ' Converts each text hyperlink selected into a working hyperlink

       For Each xCell In Selection

              ActiveSheet.Hyperlinks.Add(Anchor:=xCell, Address:=xCell.Formula)

       Next xCell

End Sub

Updates

2012-10-30 Added "Macro to Convert Text Hyperlink"

2012-08-30 Added "Dynamic Hyperlink Formula"