Add Hyperlink to newly added worksheet?

  • Thread starter Thread starter onliner
  • Start date Start date
O

onliner

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.
 
Check out
http://www.mvps.org/dmcritchie/excel/buildtoc.htm
I don't know if this will add it automatic??

Don't you like the right click on the arrows on the left off the sheet tabs.

Or

Sub SheetList_CP()
'Chip Pearson, 2002-10-29, misc.
On Error Resume Next
Application.CommandBars("Workbook Tabs").Controls("More Sheets...").Execute
Application.CommandBars("Workbook Tabs").ShowPopup
On Error GoTo 0
End Sub
 
Back
Top