| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Hyperlink macro for personal.xls
Sub Hyperlinkcell()
' Dim actual As Range Set actual = Application.InputBox(Prompt:="Select cell to hyperlink.", Type:=8) ActiveSheet.Hyperlinks.Add Anchor:=Selection, Address:="", SubAddress:=actual, TextToDisplay:=ActiveCell.Value End Sub Can anybody fix the above hyperlink macro pls. Thxs |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Macro runs in source , but not when in Personal Macro Workbook | Excel Programming | |||
| Personal macro workbook and personal.xls | Excel Discussion (Misc queries) | |||
| Intra-workbook hyperlink: macro/function to return to hyperlink ce | Excel Discussion (Misc queries) | |||
| personal.htm & personal.xls in Macro | Excel Programming | |||
Threaded Mode
