| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Add Hyperlink to newly added worksheet?
Using Excel 97; Win2K
I'm looking for a way via VBA to add a hyperlink to my "summary" worksheet each time I add a newly named worksheet which gets its name from a cell value. In other words, if I have in D6 thru D9, MySheet1 MySheet2 MySheet3 MySheet4 and then add MySheet to cell D10, have some code that adds a hyperlink in Cell D10 that takes me to MySheet5. Is this possible? Thanks. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Auto Refresh data from original worksheet to newly created copy | Excel Discussion (Misc queries) | |||
| automatically appending newly added data on worksheet to a master list worksheet | Links and Linking in Excel | |||
| Hyperlink added to an activex control button | Excel Discussion (Misc queries) | |||
| how do i get the name of a newly added sheet that i add with Sheets.Add in a vba macro in excel? | Excel Worksheet Functions | |||
| Referencing a newly created worksheet | Excel Worksheet Functions | |||
Threaded Mode
