Hi I have this workbook I use to edit data in one worksheet and then
save the edited data to a new worksheet with the tab color yellow.
The main worksheet is then cleared and ready to use again.
What I need to do is to move all the saved worksheets those with the
tab color yellow to a new workbook on my desktop I have a command
button set up to give me an Input box to name the new workbook.
It should work like this:

Command button clicked
Inputbox comes up Enter New workbook name
Click Ok
All yellow tabbed worksheets move to new workbook and delete
from main workbook.

Can it be done?

Thanks in advance
Charles


--
mrdata
------------------------------------------------------------------------
mrdata's Profile: http://www.excelforum.com/member.php...o&userid=17899
View this thread: http://www.excelforum.com/showthread...hreadid=519020