I need your help with macro, please. I am creating an Excel spreadsheet, the first worksheet is used as a control screen. I created a worksheet that I will use as a calendar template.
I want to create a macro that will allow me to enter a name in a box or field, and then when I click on a button (name create user Calendar) which is assigned to the macro, the macro will
Copy the name I entered
Make of copy of the worksheet (named Calendar template) and rename the newly copied worksheet using the name I entered early. Can you help me to accomplish this? I would really appreciate it. Thanks

This is very basic but might give you the idea. Obviously the file location would have to be changed to your template location. When you run it, it will open the template and ask for a new file name and then save it in the same location with the new name as an xls file. (Note: Workbooks.open to Editable:=True, is all one line of code.)

Sub RenameFile()

Workbooks.Open Filename:="C:\Documents and Settings\My Documents\Excel\Calender.xlt", Editable:=True

FName = InputBox("Enter a file name")

ActiveWorkbook.SaveAs Filename:=FName

End Sub