Hi folks,
I have the following macro which allows the copying of worksheets on a protected workbook.
It works fine but I was trying to replace:
sInterimName = ActiveSheet.Name
with something like
sc = Worksheets.Count
sInterimName = "Sheet" & sc.Name
In essence I want to retrieve the...