sheridan1234
New Member
- Joined
- Aug 9, 2012
- Messages
- 3
I created a spreadsheet many years ago for my work place to assist with generating weekly paperwork. All the information in the spreadsheet is used in a mail merge to generate the weekly paperwork.
My issue is this, starting last year we got a few stubborn new employees that refuse to use paste special on their own when copying information into the spreadsheet. As a result, when they paste data into the spreadsheet it erases all my underlying formulas and conditional formatting.
I need a way to disable the paste function and replace it so that anytime someone tries to paste something into the spreadsheet (by key command or mouse) it will paste special the values only and leave all my other formatting intact.
I've tried searching around on this site but I sill can't find an example where I set this up for the entire spreadsheet.
Thanks for any help,
Shane.
My issue is this, starting last year we got a few stubborn new employees that refuse to use paste special on their own when copying information into the spreadsheet. As a result, when they paste data into the spreadsheet it erases all my underlying formulas and conditional formatting.
I need a way to disable the paste function and replace it so that anytime someone tries to paste something into the spreadsheet (by key command or mouse) it will paste special the values only and leave all my other formatting intact.
I've tried searching around on this site but I sill can't find an example where I set this up for the entire spreadsheet.
Thanks for any help,
Shane.