Protection in Excel

gbaker · #1 02-27-2013, 07:42 AM

I have a workbook that is being used by other employee's. Because the input screen has links to other information, we can't cut and paste information. How do I set up the sheet so that no one can cut (by mistake) and cause reference errors. Is there somewhere under protect worksheet that would keep anyone from using the cut function.

OTPM · #2 02-28-2013, 06:35 AM

Hi
Have you tried protecting the cells you dont want changed?
To do this:
1. Select the whole worksheet and untick the protect cells tick box.
2. Select those cells that you want to protect.
3. Re-tick the protect cells tick box.
4. Protect the worksheet and add a pasword if you wish.
This should provide you with what you want.
Good luck.
Tony

gbaker · #3 02-28-2013, 06:56 AM

Hi Tony,
I did protect cells that I didn't want anyone to be able to edit. These are cells that need to be edited but I don't want anyone to be able to cut & paste, Just copy and paste so I won't have reference issues on other sheets that are in the background. I found code that seems to work well for what I am trying to do.

Code:

Option Explicit
Private Sub Workbook_SheetSelectionChange(ByVal Sh As Object, _
ByVal Target As Excel.Range)
Select Case Application.CutCopyMode
Case Is = False
'do nothing
Case Is = xlCopy
'do nothing
Case Is = xlCut
MsgBox "Please DO NOT Cut and Paste. Use Copy and Paste; then delete the source."
Application.CutCopyMode = False 'clear clipboard and cancel cut
End Select
End Sub

Thanks for your help!!!

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Password Protection	JimP	Visio	2	03-24-2011 04:23 AM
Document protection	Daved2424	Word	0	11-17-2010 01:22 AM
Help reg Protection of cell.	aligahk06	Excel	1	09-02-2009 05:45 PM
need help with document protection	jknyc	Word	1	06-22-2009 11:47 PM