You could have an event macro (_selectionchange???) that runs when you change
selections.

And one of the bad things about most macros that do anything is that they clear
the clipboard.

If you disable macros when you open the workbook, does your copy|paste work ok?

mbargfre wrote:

I copied a cell with information and then went to another cell and when I
went to right click to paste it, the paste option was greyed out so is the
paste icon in the toolbar. The Clipboard is cleared out.

--

Dave Peterson