I have an excel sheet (scoring sheet) in which most of the cells as
protected except one column, which requires users to input the scores. There three type of scoring categories allowed (as per drop don list given by me). I want to disable copying / dragging of data from one cell to another so that the type of scoring as applicable to a particular dosen't get altered.

You can disable drag & drop of cell contents:

Sub Disable_Cell_Drag_Drop()

Application.CellDragAndDrop = False

End Sub

Cheers
Shasur

http://www.dotnetdud.blogspot.com

VBA Tips & Tricks (http://www.vbadud.blogspot.com)

Thanks Shasur,

Actually my requirements are a bit more than this. Will try & list them down:

1) For particular range of cells, user should be able to input only value provided in the drop down list, and
2) User should not be able to copy (^C), cut (^X), paste (^V), fill (^D) either by using shortcut keys or toolbars or right click menus.
3) User should not be able to access the VB code so that macros cannot be altered.
4) All the above functions should be applicable to the required workbook / worksheet only.
5) How to undo all the able commands.

..... A bit lenthy one.

Once again thanks for yr response.... Hope to hear soon from u.

You can disable the Keys by using the Application.Key :

http://vbadud.blogspot.com/2007/06/a...el-macros.html

You can also disable the shortcut keys

http://vbadud.blogspot.com/2007/04/d...ght-click.html


Protecting the project (Tools--> Project Properties-->Protection--> Enable Lock Project For Viewing would help you for resticting access

Cheers
Shasur


http://www.dotnetdud.blogspot.com

VBA Tips & Tricks (http://www.vbadud.blogspot.com)