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.
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..
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks