Hi all! I have this Macro, currently working fine, just fine:

Please Login or Register  to view this content.
What this does currently (if you can'y already tell) is takes each sheet and makes it it's own workbook, then saves as the sheet name in a certain folder, then sends it in an email.

My boss has asked me to add another step. I need to show only the first five sheets ("Maloney", "Petralia", "Borek", "Leach", "Petrosino") and hide everything else. Then I need to make a copy, save it as "Horne" in the same folder, and send in an email (same steps as above). I thought I did it right, but it is saving the current workbook as Horne, and that can't happen, because I need an additional step after this where I show only six other sheets and save it as "Marose" ("Armenis", "Greene", "Padilla", "Meadors", "Gagne", "Dargusch").

This is the code I attempted the first additional step with:

Please Login or Register  to view this content.

Please... HELP!