| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
custom toolbar item to use hyperlink to open word file
Thank you!
"Gary''s Student" wrote: Something like: Sub runword() Dim s As String s = "file:///c:\x.doc" ActiveWorkbook.FollowHyperlink Address:=s End Sub will execute a hyperlink to a Word document. Just assign this macro to your button. -- Gary''s Student - gsnu200717 "Sally M" wrote: I have created a custom toolbar in Excel 2003 which opens instead of the standard toolbar when I open a particular workbook. On one of the worksheets in the workbook, I have a button that is associated with a hyperlink to a Word file. I would like to put a button on the toolbar that will run a macro to choose that hyperlink, rather than going to the button in the worksheet. I've tried to record a macro to choose the worksheet button, but it doesn't work. . . maybe because it requires a link to Word? So my question is: Is there a way to assign a button on a customized toolbar that will create a hyperlink a Word document? Thanks |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Hyperlink to open Word File | Excel Discussion (Misc queries) | |||
| Excel Hyperlink doesn't open Word doc the same way as Word does | Excel Discussion (Misc queries) | |||
| menu / toobar item for open file by name | Excel Discussion (Misc queries) | |||
| Hyperlink in Excel 2000 can't open bookmarked Word 2000 file | Excel Discussion (Misc queries) | |||
| file open via IE hyperlink causes already open files to shrink and tile | Setting up and Configuration of Excel | |||
Hybrid Mode
