I am trying make a form which contain cells with validation and conditional format. In these cells the user is required fill in the data. However, when the data is simply pasted, the validation and the format is erased, making the form unusable.
Can anybody suggest a way as to how only paste special values is enabled and the rest are disabled.
This probably would involve a VBA Code.
Can anybody suggest a way as to how only paste special values is enabled and the rest are disabled.
This probably would involve a VBA Code.
Last edited:
