I attempted to move a worksheet from one workbook to another, but when I
attempted to select the "To Book:" in the drop down box, the only workbooks I
had to choose from were the current workbook and a new workbook. The
workbook I desired to send the worksheet into was open. How do I get the
drop box to recognize other workbooks that are open?