Reverse VBA action!

[joneswesley]

I have the below macro within my spreadsheet. This was written to prevent users using the normal paste function in order to prevent formatting changes.

I need to now reverse the actions below to come back to the original settings. Does anyone know how i can do this?

Please Login or Register  to view this content.

[dominicb]

Good morning joneswesley

I need to now reverse the actions below to come back to the original settings. Does anyone know how i can do this?

Next time you post code, please remember to use the code tags (the "#" button in the posting toolbar) - I have added them for you on this occasion.

Not sure where you got this code from - Ivan F Moala has some similar code on his site, but has thoughtfully provided a way to undo the changes that it makes. Have a look at the link here for his "EnableCopyCutAndPaste" macro.

HTH

DominicB

[joneswesley]

Thanks. The fix part of his code did the trick.