fry
Active Member
- Joined
- Apr 25, 2007
- Messages
- 411
I'm using this code:
to make a copy of a template worksheet named "0000" as "New Purchase Order" and then move it to the beginning of the workbook.
My question is...
Can I add something to the line with the copy statement in it so that it names it as it copies it??
And...
Because the sheet I am copying is hidden it also hides the new "New Purchase Order" sheet so is there a command to unhide the sheet??
Thanks!!
Code:
Application.DisplayAlerts = False
Sheets("New Purchase Order").Delete
Application.DisplayAlerts = True
Worksheets("0000").Copy before:=Sheets(Worksheets.Count)
Worksheets("0000 (2)").Name = "New Purchase Order"
Worksheets("New Purchase Order").Move before:=Sheets(1)
to make a copy of a template worksheet named "0000" as "New Purchase Order" and then move it to the beginning of the workbook.
My question is...
Can I add something to the line with the copy statement in it so that it names it as it copies it??
And...
Because the sheet I am copying is hidden it also hides the new "New Purchase Order" sheet so is there a command to unhide the sheet??
Thanks!!