I have stupidly removed the 'copy' and 'paste' options of the context menu in Excel 2003 which would normally become visible with a right mouse click in the active worksheet.
I used the following code:
Sub RemoveContextMenuItem()
On Error Resume Next
CommandBars("cell").Controls("Copy").Delete
End Sub
I had put it in the active worksheet but a work colleague saved the alterations to the workbook and now every time i open excel i cannot copy or past using the context menu.
Can anyone tell me how to restore these settings?
Many thanks,
Q
I used the following code:
Sub RemoveContextMenuItem()
On Error Resume Next
CommandBars("cell").Controls("Copy").Delete
End Sub
I had put it in the active worksheet but a work colleague saved the alterations to the workbook and now every time i open excel i cannot copy or past using the context menu.
Can anyone tell me how to restore these settings?
Many thanks,
Q