how to make a copy template + make new hyperlink to new copy template.


New Member
Mar 21, 2018
Hello everyone,

I need some help to make a new macro.
Atm i have it setup to press a cell that he creat a copy of the template and it give it a new name.

Only what i really want is that he also make a new Hyperlink and put it in a new cel.

So basicly if i make a copy of the template the name will appear in cell c3, if c3 is full it will make automaticly it in cell c4 if that is full it go to c5 etc etc.
It should take the new template name and make straight a hyperlink on it to that cell.

What i do now is :

Sub NieuweEvenement()

'Popup invoerveld voor Evenement
Evenement = InputBox("Wat is de Evenement van de klant?")

'Stop wanneer Evenement leeg is of op Cancel wordt gedrukt
If Evenement = "" Then Exit Sub

'Kopieer Template sheet, en hernoem naar de Evenement
Sheets("Template Events").Copy After:=Sheets(Sheets.Count)
ActiveSheet.Name = Evenement

'Selecteer nieuwe sheet

End Sub

in the tab i have this to open the macro:

Private Sub Worksheet_SelectionChange(ByVal Target As Excel.Range)
If Not Application.Intersect(Target, Range("L4:O5")) Is Nothing Then
Call NieuweEvenement
End If
End Sub

now it make's a copy of my template but it do not add in a cell or make a hyperlink.

Anyone can help me whit this?

THanks allot

Some videos you may like

Excel Facts

What did Pito Salas invent?
Pito Salas, working for Lotus, popularized what would become to be pivot tables. It was released as Lotus Improv in 1989.

Watch MrExcel Video

Forum statistics

Latest member

This Week's Hot Topics

  • Change military grades into rank
    Afternoon all Need help with formula that will change military rank (i.e. 1, 2, 3 into Amn, A1C, SrA). Running IF formula that does not work...
    Hi The following are the errors spread across the several columns from E to Q ie. 13 columns across several sheets with more than 500 rows per...
    Hi All! How can identify that that the row to be inserted has to be inserted before 1st row with specific text in column F. If I record the...
  • Auto-Create a monthly Sign in sheet for preschool students
    The image below is what each page looks like. Above is space for the "Child Name" "Month" "Class" School days are obviously Monday-Friday but...
  • VBA vlookup multiple results
    Hi folks, Hopefully someone out there can help. I have a list to vlookup which works (ish). the lookup only picks up the first instance of the...
  • Extract values for earliest/latest times
    I am trying to put together a formula to get the earliest start time, the latest end time from column A for each person in Column B-F without the...