View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Gord Dibben Gord Dibben is offline
external usenet poster
 
Posts: 22,906
Default Need help moving a worksheet to another workbook.

Perhaps you have each workbook open in its own instance of Excel?

Close one instance and open both workbooks in a single instance.


Gord Dibben MS Excel MVP


On Thu, 14 Aug 2008 15:14:04 -0700, PM Gal <PM
wrote:

When I select the worksheet to be moved and to the Edit menu and click- Move
or Copy Sheet- the workbook to which I want to move the worksheet doesn't
appear in the To BOX , eventhough I have the receiving workbook open. What
must I do to have the new workbook listed in the TO BOX so I can complete the
worksheet's move?