I have a spreadsheet which a user must complete, but he must select how many times the form must get created.
My coding allows that, but I'm protecting my sheet.
My coding below allows everything that I want, BUT after Protecting, the user can't insert a Hyperlink. The option is Greyed out, even if I protect it with that option.
Here is my coding:
Private Sub CommandButton1_Click()
Dim rws As Long
Dim xCount As Integer
n = Sheets("DataEntry").Range("c7")
rws = .Rows.Count + 1
.Resize(rws).Copy Destination:=.Offset(rws).Resize(rws * (n - 1))