Seckin set up a worksheet for his co-workers with great conditional formatting. Unfortunately, the co-worker uses Ctrl+V instead of Paste Special Values, which destroys the conditional formatting and/or data validation. In this episode, record a simple macro that changes Ctrl+V to Paste Special Values.
Transcript of the video:
MrExcel podcast is sponsored by Easy-XL.
Learn Excel form MrExcel podcast episode 1828.
Prevent Ctrl-v to Paste.
Hey, welcome back to the MrExcel netcast.
I'm Bill Jelen.
Today's question send in via YouTube by Seckin.
He had some conditional formatting and his co-worker always forgets to paste by special values instead she presses control+V that everything is gone.
How to solve this problem?
So, here I have some conditional formatting here I have some Data Validation both of these can get wiped out if someone would copy, and then instead of doing right click, paste special values or right click, paste special values or Alt+E+S+V or whatever it is to paste special values.
If they would just do a regular old paste, baam it overwrites the conditional formatting.
It overwrites the data validation and second has to set it up all over again.
Well, hey! One way to do this if they're really using control+V and not using paste, then we can assign control+V to a Macro.
So, back here on the View tab.
First let's copy some things control+C and then Macros, record a Macro and we'll say AlwaysPasteValues and assign it to control+V and store the Macro in this workbook, click OK and all we're going to do is Alt+E+S+V, click OK and then stop recording and that's all it is.
So, now if we would select some data 1, 2, 3 copy that and come over here and press control+V.
See it did paste values instead of doing the control+V.
Now, that's only going to work if your co-worker is a control+V kind of person, she uses anything else to paste then she's going to be over able to over right that, but that's the beautiful thing about the Macro, shortcut key it always overwrites the equivalent shortcut key.
I've seen some people create what they call dictator applications where they have 25 Macros assigned to all the shortcut keys just to make sure that no one gets to use a and the shortcut keys they just it's a Macro that does nothing, but it's assigned to control+C or something like that it prevents people from using those shortcuts.
So, there you go.
Great question send in by Seckin.
All right! Well, hey I wanna thank you stopping by.
We'll see you next time for another netcast from MrExcel.
Learn Excel form MrExcel podcast episode 1828.
Prevent Ctrl-v to Paste.
Hey, welcome back to the MrExcel netcast.
I'm Bill Jelen.
Today's question send in via YouTube by Seckin.
He had some conditional formatting and his co-worker always forgets to paste by special values instead she presses control+V that everything is gone.
How to solve this problem?
So, here I have some conditional formatting here I have some Data Validation both of these can get wiped out if someone would copy, and then instead of doing right click, paste special values or right click, paste special values or Alt+E+S+V or whatever it is to paste special values.
If they would just do a regular old paste, baam it overwrites the conditional formatting.
It overwrites the data validation and second has to set it up all over again.
Well, hey! One way to do this if they're really using control+V and not using paste, then we can assign control+V to a Macro.
So, back here on the View tab.
First let's copy some things control+C and then Macros, record a Macro and we'll say AlwaysPasteValues and assign it to control+V and store the Macro in this workbook, click OK and all we're going to do is Alt+E+S+V, click OK and then stop recording and that's all it is.
So, now if we would select some data 1, 2, 3 copy that and come over here and press control+V.
See it did paste values instead of doing the control+V.
Now, that's only going to work if your co-worker is a control+V kind of person, she uses anything else to paste then she's going to be over able to over right that, but that's the beautiful thing about the Macro, shortcut key it always overwrites the equivalent shortcut key.
I've seen some people create what they call dictator applications where they have 25 Macros assigned to all the shortcut keys just to make sure that no one gets to use a and the shortcut keys they just it's a Macro that does nothing, but it's assigned to control+C or something like that it prevents people from using those shortcuts.
So, there you go.
Great question send in by Seckin.
All right! Well, hey I wanna thank you stopping by.
We'll see you next time for another netcast from MrExcel.
