other workbook does not appear in the drop down box when I attemp.
 

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?

other workbook does not appear in the drop down box when I attemp.
 

Is it possible you have two instances of Excel open? If so, try opening both
workbooks under the same instance of Excel.
--
Kevin Vaughn


"Daniel Loch" wrote:

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?

other workbook does not appear in the drop down box when I att
 

Kevin,

You are a superstar. I greatly appreciate your insight. You solved my
problem perfectly.

Best Regards,

Dan

"Kevin Vaughn" wrote:

Is it possible you have two instances of Excel open? If so, try opening both
workbooks under the same instance of Excel.
--
Kevin Vaughn


"Daniel Loch" wrote:

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?

other workbook does not appear in the drop down box when I att
 

Great. Glad it helped.
--
Kevin Vaughn


"Daniel Loch" wrote:

Kevin,

You are a superstar. I greatly appreciate your insight. You solved my
problem perfectly.

Best Regards,

Dan

"Kevin Vaughn" wrote:

Is it possible you have two instances of Excel open? If so, try opening both
workbooks under the same instance of Excel.
--
Kevin Vaughn


"Daniel Loch" wrote:

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?