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

D

Daniel Loch

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?
 
K

Kevin Vaughn

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

Daniel Loch

Kevin,

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

Best Regards,

Dan
 
K

Kevin Vaughn

Great. Glad it helped.
--
Kevin Vaughn


Daniel Loch said:
Kevin,

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

Best Regards,

Dan
 
Top