How to create a directory of all the Worksheets in Excel. Create a list of worksheets linked to the directory worksheet. Check out my online courses
Vba code to select worksheet name and create sheet with link to directory worksheet
Sub add_new_sheet()
Dim sheet_name_to_create As String
Dim sh As Worksheet
Dim oRng As Range
sheet_name_to_create = ActiveCell.Value
Set oRng = ActiveCell
Set sh = Sheets(“directory”)
Sheets.Add(After:=Sheets(Sheets.Count)).Name = sheet_name_to_create
sh.Activate
sh.Hyperlinks.Add oRng, “”, “‘” & sheet_name_to_create & “‘!A1”, _
“Go to ” & sheet_name_to_create, sheet_name_to_create
Set oRng = Nothing
End Sub
For more help visit my website or email me at easyexcelanswers@gmail.com
I am able to provide online help on your computer at a reasonable rate.
MY videos are all created on Camtasia.
Follow me on Facebook
Watch more new videos about Excel Office | Synthesized by Mindovermetal English
Very amazing code. gives us more and more vba codes they are a real help 🙂
Very practice, thank you