Select destination and press Enter or choose Paste

Dear all,

Every time I try to copy and paste using right click on a spreadsheet, the data is pasted but I cannot do anything else unless I press the Enter key. By doing so, the data is pasted once again with all formats. At the bottom of the screen, I get the following message which will not disappear unless I press Enter: Select destination and press Enter or choose Paste.

I think that my coding (which is not linked to any copy and paste action) affects the paste function/clipboard somehow. The first coding is linked to a command button and is about hiding and unhiding certain columns and setting the print area.

The second coding is meant to ensure that all the data entered in certain areas is in uppercase and the second part is to ensure that numbers entered in two different columns are rounded to 2 decimal places.

Here is the coding (kindly provided by far more clever people than me) I have in the workbook:

Please Login or Register  to view this content.

The same problem happens whether I use Excel 2003 or 2007 so I don't think it is related to the version of Excel.

Thank you very much for any help that you might provide.

Regards,
Cdmg

Hello cdmg,

You turn screen updating off in your code, but do not turn it back on. Screen updating is needs to be restored after the macro has finished.