Question: how to copy multiple sheets to a new workbook in excel vba?
Answer: Press and hold Ctrl and select multiple sheets in your workbook., Run CopySelectedSheetsToNewWorkbooks macro.