Disable cut copy paste

[baleshst]

I was stunned to see, even after password protecting a particular sheet you could easily cut/copy paste it to another sheet. Thereby compromising the data of the protected sheet.

Is there anyway I could disable cut copy paste.
Please do not share a vba code. I am looking out for answers other than vba.

 

[Cindy Ellis]

If you are using Excel 2007 or later, you can choose to prevent the cells from being selected, thereby preventing them from being copied & pasted.
Would that resolve the issue? (You didn't mention which version of Excel you're using.)
Cindy

 

[baleshst]

Ya, I think that shall help. How do we do that?? I am using excel 2007

 

[Cindy Ellis]

From the "Home" tab, click the "Format" button in the Cells group. Near the bottom of the menu that displays, find the Protection group and select "Protect Sheet". You will probably see check marks for the first 2 options, "Select Locked Cells" and "Select Unlocked Cells". Uncheck those 2 options. Add a password (but keep track of it...no legit way to recover it if you lose it), then accept the changes, and re-enter the password in the next popup.

When I tried this, I couldn't select or copy any cells from the worksheet. Copying the worksheet from a right-click on the tab name did copy the worksheet, but the cells were still not selectable.
This is not perfect (it won't stop determined intentional hacking/cracking), but will prevent unintentional or casual copy/paste.

Hope this helps,

Cindy

 

[ali zaib]

Open vba with Alt "F11" key in "view tab" choose "project explorer" choose your sheet you want to protect in "project explorer you will see "scroll area"
suppose you sat "A1:A2" . its your scroll area
its a new thing your sheet will see unprotected no need password no need any protection

 

[baleshst]

Isnt their any other way, where in i dont have to step into vba to do this.
Also i tried setting the scroll area in *.xlsm, however after saving,closing and then reopening, the scroll area criteria doesnt work.

 

[Cindy Ellis]

Did you try what I suggested?

 

[baleshst]

Hey Cindy,

Thanks,
Problem solved.
I dont know how i missed your suggestion in the first place.

 

[Cindy Ellis]

The steps are in the fourth email in this thread.