TheWennerWoman
Active Member
- Joined
- Aug 1, 2019
- Messages
- 271
- Office Version
- 365
- Platform
- Windows
\hello,
We have a spreadsheet with some considerable data validation and conditional formatting to prevent "dirty data" from being entered (no trailing spaces, no leading spaces, max 35 characters etc) but we've found that if users paste data in then it bypasses the conditional formatting (I think the data validation is still there).
If users want to paste into columns D, E, F and H, is there a way I can force them to paste special values? Even if it's just a message box telling them they can't paste that will be better than nothing.
Many thanks.
We have a spreadsheet with some considerable data validation and conditional formatting to prevent "dirty data" from being entered (no trailing spaces, no leading spaces, max 35 characters etc) but we've found that if users paste data in then it bypasses the conditional formatting (I think the data validation is still there).
If users want to paste into columns D, E, F and H, is there a way I can force them to paste special values? Even if it's just a message box telling them they can't paste that will be better than nothing.
Many thanks.