Good morning Kensanjose

You can achieve part of what you need to do. Use Tools Protection
Protect Sheet to apply the protection. Prior to doing this select the
cells that people are going to be able to edit and hit ctrl + 1. Go to
the protection tab and uncheck the locked box.

You can disable the right click event by inserting this code into the
ThisWorkbook pane of the VBE:

Private Sub Workbook_SheetBeforeRightClick(ByVal Sh As Object, _
ByVal Target As Range, Cancel As Boolean)
Cancel = True
End Sub

However, users will still be able to copy a workbook through the menu
Edit Move or Copy Sheet (use Tools Protection Protect Workbook to
prevent this) and keyboard shortcuts. As such it is very difficult to
stop users from doing a whole range of things, and impossible to
control a worksheet so tightly that a determined person cannot
circumnavigate.

HTH

DominicB


--
dominicb
------------------------------------------------------------------------
dominicb's Profile: http://www.excelforum.com/member.php...o&userid=18932
View this thread: http://www.excelforum.com/showthread...hreadid=385319