Copying & Pasting

[sjmonroe]

All of a sudden when I try to copy a sheet 1 from a workbook A to workbook B
sheet 1 it will not let me with out pulling up the office clip board and it
never used to do this. I used to be able to just highlight, right click, and
hit copy then go to the other workbook, right click, and hit paste. Also it
will not copy the formulas over just the values. Any suggestions why?

 

[p45cal]

Not the same instance of Excel

 

[Gord Dibben]

Sounds like you are running two instances of Excel with a workbook in each.

These will not communicate.

Close one instance and open both workbooks in a single instance then do your
copy/pasting.


Gord Dibben MS Excel MVP

 

[Sueb]

I am having a similiar problem. My mouse functions for "right" click do not
function since Saturday. Did you get an anser to your question yet?
Sue

 

[Gord Dibben]

That is not a similar problem.

No right-click menu when you right-click on a cell?

Perhaps some code you ran disabled it.

Alt + F11 to open VBE.

View>Immediate Window.

Copy this into that window and hit ENTER key.

Application.CommandBars("Cell").Enabled = True

Alt + q to return to Excel............OK now?


Gord Dibben MS Excel MVP

 

[sjmonroe]

How do I open both workbooks in a single instance? and why has this never
done this before? And if you open the clipboard then it will allow you to do
it but the formulas and formatting will not be there. If you respond back
please "dumb down" the answer. Thanks

 

[Gord Dibben]

Save and Close out second workbook and click on the "X" to close Excel.

Do you still have the other workbook open in a session of Excel?

If so, you had two instances of Excel running.

File>Open..........open workbook you just closed.


Gord