a quickie

[fry]

I'm using this 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!!

 

[dave3009]

Hi

To make a sheet visible use

Worksheet("SheetName").Visible = xlSheetVisible

In your code.

HTH


Dave

 

[erik.van.geit]

posted twice
http://www.mrexcel.com/board2/viewtopic.php?t=285336

 

[fry]

Thanks Dave, any ideas with the naming bit???

Cheers Erik I know, it was my mistake as my puter froze!!