Apr 11 2022 11:20 AM
Is there a way to copy all tabs in a workbook to a new workbook. I have tried Ctrl and clicking on the tabs, but they will not all highlight,
Apr 11 2022 12:04 PM
@johnjr1955 Why not just save the workbook under a different name and continue from there.
Apr 11 2022 12:46 PM - edited Apr 11 2022 12:47 PM
Right-click any sheet in workbook - Select all sheets.
Right-click again - Move or Copy
to book: new book
Check "create a copy"
(Don't forget to ungroup the original workbook.)
Apr 17 2022 06:10 PM
@Riny_van_Eekelen The workbook has over 100 tabs. We are looking to just copy four of the tabs to a new workbook.