gmr4evr1,
I just can't figure out how to do that. I keep getting errors with the ways I try to put the name in. I'm kinda new to this. My original workbook name is "FT" and the sheet name is "4T-Copy". I also need it to save with my password the way it saves the new sheet with: ActiveSheet.Protect "Password"
I have tried several different ways of naming it but just can't get it to work.
Thanks for any suggestions,
Foos Master