Lock to copy/ modification data

on executing my workbook i need to disable copy/cut mode or any modification in this workbook. User should able to see but prevent from any modifications and to copy data/contents from my workbook.

protect and lock every sheet. also, set each sheets 'ScrollArea' to a small
range - that would prevent the user from even being able to select any cells

you can also use a split window and protect the sheet to prevent users
selecting anaything...here are a few ideas
Sub Lock_up()

With ActiveWindow
.SplitRow = 29
.SplitColumn = 10
.FreezePanes = True
End With
Range("L32").Select
Application.Width = 494.25
Application.Height = 485.25
ActiveSheet.Protect DrawingObjects:=True, Contents:=True, Scenarios:=True
ActiveSheet.EnableSelection = xlNoSelection
ActiveWorkbook.Protect Structure:=True, Windows:=True

End Sub


"ilyaskazi" wrote:

>
> on executing my workbook i need to disable copy/cut mode or any
> modification in this workbook. User should able to see but prevent from
> any modifications and to copy data/contents from my workbook.
>
>
> --
> ilyaskazi
> ------------------------------------------------------------------------
> ilyaskazi's Profile: http://www.excelforum.com/member.php...o&userid=23969
> View this thread: http://www.excelforum.com/showthread...hreadid=476081
>
>

Great!!!!! It works.

Thankyou..