RE: [ExcelVBA] how to disable paste option

 

 Manikandan,

If the sheet is protected, it should not allow a paste to be performed.

I tried replicating the symptoms by opening two spreadsheets.  I protect one, and then copied a cell of data from the other.  When I try to paste it to the protected one, it does not allow it.  My question is, does your code possible have an "unprotect" somewhere?

 

Tim

 

-----Original Message-----
From: "Raghavan Manikandan geethanjali_mani@yahoo.com [ExcelVBA]" <ExcelVBA@yahoogroups.com>
Sent: Thursday, May 15, 2014 12:21am
To: ExcelVBA@yahoogroups.com
Subject: [ExcelVBA] how to disable paste option

 

HI Team,

 

Recently I experienced with an issue with the pasting the values from the different excel file which replaces the validated cells.

  

I have given below the details of the issue I have seen in my macro file :-

  

1)     There are few cells in the excel file which is having the validation wherein I need to select the values which I have given in the validation cells.

  

2)     When a person who copies the data from other excel file he could able to paste it directly in the validation cells in the existing file which replaces the validation option and the value which was not listed in the validation cells.

  

3)     The Excel sheet is protected.

 

Please advise me how to disable the paste option (Ctrl +v, right click and paste etc.,) for the respective excel file to avoid this kind of issues.

 

Regards

Manikandan Raghavan

__._,_.___

Reply via web post

•

Reply to sender

•

Reply to group

•

Start a New Topic

•

Messages in this topic (2)

---

----------------------------------
Be sure to check out TechTrax Ezine for many, free Excel VBA articles! Go here: http://www.mousetrax.com/techtrax to enter the ezine, then search the ARCHIVES for EXCEL VBA.

----------------------------------
Visit our ExcelVBA group home page for more info and support files:
http://groups.yahoo.com/group/ExcelVBA

----------------------------------
More free tutorials and resources available at:
http://www.mousetrax.com

----------------------------------

Visit Your Group

• Privacy • Unsubscribe • Terms of Use

.

__,_._,___