I have a workbook that works like a book of templates and I want one button to copy the selected sheet to a new workbook. I used record macro and I right clicked on the sheet..Move or Copy... etc to produce this result.
problem is that i want the same button for every sheet. Any help would be greatly appreciated.Sheets("Config VI").Select Sheets("Config VI").Copy
Thanks