Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Select sheet tabs in workbook & save to separate workbook files
Product is Excel 2003
I have workbooks that have up to 130 sheet tabs. After selecting all 130 sheet tabs, is there a function or macro that will allow me to copy each of the 130 sheet tabs into it's own separate 130 workbooks at one time. ---------------- This post is a suggestion for Microsoft, and Microsoft responds to the suggestions with the most votes. To vote for this suggestion, click the "I Agree" button in the message pane. If you do not see the button, follow this link to open the suggestion in the Microsoft Web-based Newsreader and then click "I Agree" in the message pane. http://www.microsoft.com/office/comm...et.f unctions |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Select sheet tabs in workbook & save to separate workbook files
Ron de Bruin has code at his site to do just that
http://www.rondebruin.nl/tips.htm "stratocaster" wrote: Product is Excel 2003 I have workbooks that have up to 130 sheet tabs. After selecting all 130 sheet tabs, is there a function or macro that will allow me to copy each of the 130 sheet tabs into it's own separate 130 workbooks at one time. ---------------- This post is a suggestion for Microsoft, and Microsoft responds to the suggestions with the most votes. To vote for this suggestion, click the "I Agree" button in the message pane. If you do not see the button, follow this link to open the suggestion in the Microsoft Web-based Newsreader and then click "I Agree" in the message pane. http://www.microsoft.com/office/comm...et.f unctions |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Select sheet tabs in workbook & save to separate workbook files
Hi stratocaster
You can use this macro http://www.rondebruin.nl/copy6.htm -- Regards Ron de Bruin http://www.rondebruin.nl "stratocaster" wrote in message ... Product is Excel 2003 I have workbooks that have up to 130 sheet tabs. After selecting all 130 sheet tabs, is there a function or macro that will allow me to copy each of the 130 sheet tabs into it's own separate 130 workbooks at one time. ---------------- This post is a suggestion for Microsoft, and Microsoft responds to the suggestions with the most votes. To vote for this suggestion, click the "I Agree" button in the message pane. If you do not see the button, follow this link to open the suggestion in the Microsoft Web-based Newsreader and then click "I Agree" in the message pane. http://www.microsoft.com/office/comm...et.f unctions |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Protect Workbook vs Worksheet?? | Excel Worksheet Functions | |||
printing multiple sheet tabs to image file | Excel Discussion (Misc queries) | |||
Stubborn toolbars in Excel | Excel Discussion (Misc queries) | |||
Problem with shared workbook (history sheet) | Excel Worksheet Functions | |||
Sheet tabs disappear sometimes in Internet Explorer | Excel Discussion (Misc queries) |