Any idea on how to prevent pasting of data to a particular range which has data validation. user should be able to select from the drop down list but not paste from other resource.
I did but it didn't turn out as you showed in the video. In VB, below your line, I have entered this script [ Range ("A1") = ActiveCell.Address ]. Is it because of this script that your script is not working?
Hi Dinesh, I apply the script to Application.CutCopyMode = False, it does apply to data restriction but not applies to image copy&paste. I have a excel document that has a stamp image which is copied from another Excel file fro each user having their own password. However the main file that they use are common. Hence it will consist of other users' image stamp which can be copy wrongly if this user by pass in using his User personal stamp file (password). Please advise how I can disable Cut/copy&paste feature by row 14 (image stamp) within a given worksheet but is able to copy the stamp from another file owned by the user to the new cell of row 14. The main excel document is the Quality inspection record where the stamp identifies the QA inspector and their stamp is also store inanother excel document ,password protect by the QA inspector. Please advise
Thanks sir for your suggestions but I can easily copy the text and paste this on any notepad after applying your code and vba project password protection is working fine. Please suggest.
This is a very simple solution but it is also very simple to defeat in a number of ways 1. open the workbook with macros disabled, or 2. change to a different worksheet then "Paste" (Note the selection hasn't changed), or 3. save the workbook as an xlsx file then re-open the xlsx file the upshot is this method should not be relied upon to protect your data
I agree, but it important that people understand the limitations. Many instances of Excel have macros disabled by default so even a non experts would defeat this. Excel was never designed to be secure, so it is very difficult to lock it down in anything other than a very superficial way.
Protect the worksheet and the workbook and don't allow selection of cells. This needs to be done without VBA code. Now try and change the data or copy it. You may also save it as a '.xlsx' file. Share your feed-back.
Dinesh Kumar Takyar this a far better solution, though still not totally secure. As few people are likely to read these comments can I suggest you add/change the video itself
These two links will guide: www.exceltrainingvideos.com/how-to-display-pictures-on-excel-worksheet-using-vba/ www.exceltrainingvideos.com/place-picture-in-excel-worksheet-cell-using-vba/ Or search www.exceltrainingvideos.com
Hi In this tutorial you told how to prevent data copying. But, will you tell me how to prevent data copy for a particular range Like ("A1:A20") ? I mean, I want to prevent for 1 particular column which ever we provide range Regards, Mukund
This was the nicest video I have found. Thanks, Dinesh.
Most welcome!
Any idea on how to prevent pasting of data to a particular range which has data validation. user should be able to select from the drop down list but not paste from other resource.
Query not clear. You can always specify from where you wish to copy and where to paste the data.
Odyssy: did you find the solution or macro for what you were asking?
I did but it didn't turn out as you showed in the video. In VB, below your line, I have entered this script [ Range ("A1") = ActiveCell.Address ]. Is it because of this script that your script is not working?
Can't say.
but still Alt+e+s+v was working into the sheet and suggest me if its possible to avoid the pasted as values
Query not clear.
@@Exceltrainingvideos I've tried pasted values from different workbook still it's working
Hi Dinesh, I apply the script to Application.CutCopyMode = False, it does apply to data restriction but not applies to image copy&paste. I have a excel document that has a stamp image which is copied from another Excel file fro each user having their own password. However the main file that they use are common. Hence it will consist of other users' image stamp which can be copy wrongly if this user by pass in using his User personal stamp file (password). Please advise how I can disable Cut/copy&paste feature by row 14 (image stamp) within a given worksheet but is able to copy the stamp from another file owned by the user to the new cell of row 14. The main excel document is the Quality inspection record where the stamp identifies the QA inspector and their stamp is also store inanother excel document ,password protect by the QA inspector. Please advise
Try locking the image.
Hi! Not working on Office 365 version. Thanks
Works for me. Check your clipboard after writing the code, saving the file and finally copying some data.
Thanks, this is a tute I was anticipating and If you have time please consider my request God bless you, siddeek
how can I disable this cut coping function in a particular range?
That's what you learned just now!
but if you close the file and re-open, then copy and paste is active again
This link will help:
www.exceltrainingvideos.com/prevent-data-copying/
Thanks sir for your suggestions but I can easily copy the text and paste this on any notepad after applying your code and vba project password protection is working fine. Please suggest.
This link will show you how to add a greater security layer: www.exceltrainingvideos.com/prevent-data-copying/
Great Job ! Thumbs UP
After using this formula and now normal copy C option is not working. How to rectify this
The macro is made to stop people from copying data!
Place an apostrophe before the line of code like so:
'Application.CutCopyMode = False
I am looking to apply this method on a range of data only is it possible?
This link might help: www.exceltrainingvideos.com/tag/automatically-lock-worksheet-cells-after-data-entry-using-vba/
VERY GOOD INFORMATION
So nice of you.
This is not safe. I can still copy dta by using Ctrl C and paste it using Ctrl V in other open excel file.
How to provide another layer of protection to your data:
www.exceltrainingvideos.com/prevent-data-copying/
This is a very simple solution but it is also very simple to defeat in a number of ways
1. open the workbook with macros disabled, or
2. change to a different worksheet then "Paste" (Note the selection hasn't changed), or
3. save the workbook as an xlsx file then re-open the xlsx file
the upshot is this method should not be relied upon to protect your data
This is the starting point. You can build more layers of data protection. Of course, 'Experts' can beat many things in Excel!
I agree, but it important that people understand the limitations. Many instances of Excel have macros disabled by default so even a non experts would defeat this.
Excel was never designed to be secure, so it is very difficult to lock it down in anything other than a very superficial way.
Protect the worksheet and the workbook and don't allow selection of cells. This needs to be done without VBA code. Now try and change the data or copy it. You may also save it as a '.xlsx' file. Share your feed-back.
Dinesh Kumar Takyar this a far better solution, though still not totally secure. As few people are likely to read these comments can I suggest you add/change the video itself
how to prevent from pasting?
You can lock the cells and protect the worksheet. In Excel such security features can be easily overcome by people determined to play mischief.
Dear sir
Using VBA macro
Can you explain how to add picture from folder based on cell value (picture name)
These two links will guide:
www.exceltrainingvideos.com/how-to-display-pictures-on-excel-worksheet-using-vba/
www.exceltrainingvideos.com/place-picture-in-excel-worksheet-cell-using-vba/
Or search www.exceltrainingvideos.com
Thank you very much sir
Vba code protect workbook with IP address for misuse...
Noted
Hi
In this tutorial you told how to prevent data copying. But, will you tell me how to prevent data copy for a particular range
Like ("A1:A20") ?
I mean, I want to prevent for 1 particular column which ever we provide range
Regards,
Mukund
This link should help: www.exceltrainingvideos.com/prevent-data-copying/
Thank you for your reply,
But, Can we make user to enter the data manually ? Just, By disabling cutcopypaste mode
Unfortunately it's not working.
Check your working!
After this can we allow for specific person by using password
Plz.reply sir
This link will help: www.exceltrainingvideos.com/protect-specific-excel-worksheets-using-vba/
Or search www.exceltrainingvideos.com