elenakotanchyan
New Member
- Joined
- Jul 13, 2023
- Messages
- 10
- Office Version
- 365
- Platform
- Windows
- MacOS
- Web
Hi,
I am providing clients with feedback on their reports. I send them excel file where they input their response in one column. I have noticed that they copy and paste some of my responses instead of just typing out their own response. I was able to deactivate copy and paste on the entire worksheet but I was wondering if there is a way to use VBA code to deactivate pasting into a specified cell range (in my case E6:E504) and not the entire workbook/worksheet?
Thank you!
I am providing clients with feedback on their reports. I send them excel file where they input their response in one column. I have noticed that they copy and paste some of my responses instead of just typing out their own response. I was able to deactivate copy and paste on the entire worksheet but I was wondering if there is a way to use VBA code to deactivate pasting into a specified cell range (in my case E6:E504) and not the entire workbook/worksheet?
Thank you!