Ahh....yes I did. Let me change and see if that was the problem. With the amount of code I've got for the format sub, it will probably be easier to use Steve's suggestion though. Is this the syntax to use to copy a worksheet, instead of adding one in the commandbutton code above?
[VBA]wks = Sheets("EmpMaster").Copy After:=Worksheets(Worksheets.Count)
[/VBA]