| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Create a Hyperlink as part of a macro
I'm trying to set up a macro where each time it runs, it inserts a new
worksheet with a hyperlink from the initial sheet to the new one. However, when I run the macro, the hyperlink always takes me to the worksheet I used when recording the macro. I think the problem is that the hyperlink I set up was to a specific worksheet only, so I'm wondering if there is a way to program the macro to update the hyperlink to the new worksheet each time. Can anyone help? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do I create a hyperlink to a cell with the hyperlink function | Excel Worksheet Functions | |||
| excel - create a macro to use cell text as part of a file name | New Users to Excel | |||
| How to use cell data as part of hyperlink function | Excel Worksheet Functions | |||
| Is there a function to extract the URL part of a hyperlink in another cell? | Excel Worksheet Functions | |||
| How do I find and replace part of a hyperlink that isn't visible? | Excel Discussion (Misc queries) | |||
Threaded Mode
