Dear All
Need your help for VBA Code to Restrict User To Paste Special Values Only In Particular WorkBook.
I' am having one sheet for which I' have found a work around solution for the data validation / formulas and other protection. Hence if there is any code which will act to paste special values only when user try to paste something in the workbook.
Any help will be appreciated.
Thanks
MG
Whether copy paste needs to be restricted in certain range or something else?
If your problem is solved, then please mark the thread as SOLVED>>Above your first post>>Thread Tools>>
Mark your thread as Solved
If the suggestion helps you, then Click *below to Add Reputation
HiSixthsense
I' don't want to restrict Copy Paste.. only when the user try to paste something in the workbook, it should be paste special values only. so may be user have copied the contents from another workbook, or word, or notepad, or from the same workbook's sheet THE PASTE SHOULD BE "VALUES ONLY"
Thanks
Waiting for your Reply
MG
Not sure how to achieve it, me too awaiting to know the possible method
Thanks Anyway
And i am joining the Queue. Me too want to know how to do that.
Thanks Anyway
I' Got It
Hi, [email protected],
do you mind sharing your solution? And please mark the thread solved. TIA.
Ciao,
Holger
Use Code-Tags for showing your code: [code] Your Code here [/code]
Please mark your question Solved if there has been offered a solution that works fine for you
HaHoBe - Come online on GMAIL, You have my ID
if you have a solution please post it here openly. otherwise why should anyone here continue to try and answer any of your questions?
Josie
if at first you don't succeed try doing it the way your wife told you to
PASTE SPECIAL VALUES.xlsm
Find the attached file for an example of forcefully paste special option
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Originally Posted by 
Bookmarks