Right Click in cell, only gives option to paste, nothing has been copied

SrDPLVO · #1 07-01-2016, 09:28 AM

When I right click in a cell to copy, it only gives me the option to paste. I have not copied anything. There are no other options other than paste listed. How do I get the other options back?

cobbe · #2 07-02-2016, 02:27 AM

Try this:

Code:

Sub Enable_MouseMenu()
  CommandBars("Cell").Enabled = True
End Sub

SrDPLVO · #3 07-14-2016, 11:39 AM

I fixed it with:

Sub ResetContextMenu()
CommandBars("Cell").Reset
End Sub

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
How to remove the "Delete" option when I right click on sheet tab - HELP HELP HELP	barryoffshore	Excel	2	06-23-2014 04:57 AM
paste option Keep source formatting missing through remote app	mtrento	Excel	1	03-07-2012 09:44 AM
Copy option in Outlook 2007 using a right click	mujahid1986	Outlook	2	02-06-2012 02:40 AM
Chosen option of drop-down changes another cell content	Weed	Word	1	01-26-2012 02:44 PM
option Paste special...as 'Microsoft Excel Chart Object' NOT available	Intruder	PowerPoint	0	12-24-2010 06:28 AM