Hi,

I just want to share my copy/paste code with 2 futures:
- default copy one cells value without a carriage-return/line-feed (CR/LF) pressing Ctrl-C
- default paste without formats when pressing Ctrl+V
All this without losing undo/redo

Still want to copy the format? Just click the paste button in the ribbon.

First we need to add 2 buttons that will pass only text. range-text <> html-text
- Click File/Options/"Quick Access Toolbar"
- Select "All Commands" under "Choose commands from:"
- Select "Paste Values" and click "Add"
- Select "Paste and Keep Text Only" and click "Add"
- Click "OK"
If anyone knows how to add these buttons with VBA-code, please share it. Thanks!

Now press "Alt" and find out what number those 2 added buttons have been given and change the "4" and "5" accordingly in following code...

For newbies: While on a excel-sheet press Alt+F11 to open the VBA editor, press Ctrl+R and insert a module pressing Alt+I M and add this code:
Please Login or Register  to view this content.
Now we capture Ctrl+V and Ctrl+C
Press Ctrl+R, select ThisWorkbook and add this code:
Please Login or Register  to view this content.