software

I attempted to move a worksheet from one workbook to another, but when I
attempted to select the quot;To Book:quot; 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?

Is it possible you have two instances of Excel open? If so, try opening both
workbooks under the same instance of Excel.
--
Kevin Vaughnquot;Daniel Lochquot; wrote:

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

Kevin,

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

Best Regards,

Dan

quot;Kevin Vaughnquot; wrote:

gt; Is it possible you have two instances of Excel open? If so, try opening both
gt; workbooks under the same instance of Excel.
gt; --
gt; Kevin Vaughn
gt;
gt;
gt; quot;Daniel Lochquot; wrote:
gt;
gt; gt; I attempted to move a worksheet from one workbook to another, but when I
gt; gt; attempted to select the quot;To Book:quot; in the drop down box, the only workbooks I
gt; gt; had to choose from were the current workbook and a new workbook. The
gt; gt; workbook I desired to send the worksheet into was open. How do I get the
gt; gt; drop box to recognize other workbooks that are open?

Great. Glad it helped.
--
Kevin Vaughnquot;Daniel Lochquot; wrote:

gt; Kevin,
gt;
gt; You are a superstar. I greatly appreciate your insight. You solved my
gt; problem perfectly.
gt;
gt; Best Regards,
gt;
gt; Dan
gt;
gt; quot;Kevin Vaughnquot; wrote:
gt;
gt; gt; Is it possible you have two instances of Excel open? If so, try opening both
gt; gt; workbooks under the same instance of Excel.
gt; gt; --
gt; gt; Kevin Vaughn
gt; gt;
gt; gt;
gt; gt; quot;Daniel Lochquot; wrote:
gt; gt;
gt; gt; gt; I attempted to move a worksheet from one workbook to another, but when I
gt; gt; gt; attempted to select the quot;To Book:quot; in the drop down box, the only workbooks I
gt; gt; gt; had to choose from were the current workbook and a new workbook. The
gt; gt; gt; workbook I desired to send the worksheet into was open. How do I get the
gt; gt; gt; drop box to recognize other workbooks that are open?