Hi,

How do I prevent someone copying data from cells in excel? I am using excel
2000.

regards,

Matt

Hi

Only leaving all cells empty :-))


--
Arvi Laanemets
( My real mail address: arvi.laanemets<attarkon.ee )



"mattguerilla" wrote in message
...
Hi,

How do I prevent someone copying data from cells in excel? I am using
excel
2000.

regards,

Matt

Paste the following in ThisWorkbook code:

HTH
--
AP

'-----------------------
Private Sub Workbook_Open()
setCutCopy False
End Sub

Private Sub Workbook_BeforeClose(Cancel As Boolean)
setCutCopy True
End Sub


Sub setCutCopy(bSet As Boolean)
Const iIdCopy = 19
Const iIdCut = 21
CommandBars("Standard").FindControl(ID:=iIdCopy).V isible = bSet
CommandBars("Edit").FindControl(ID:=iIdCopy).Visib le = bSet
CommandBars("Cell").FindControl(ID:=iIdCopy).Visib le = bSet

CommandBars("Standard").FindControl(ID:=iIdCut).Vi sible = bSet
CommandBars("Edit").FindControl(ID:=iIdCut).Visibl e = bSet
CommandBars("Cell").FindControl(ID:=iIdCut).Visibl e = bSet

If bSet Then
Application.OnKey "^c"
Application.OnKey "^x"
Else
Application.OnKey "^c", ""
Application.OnKey "^x", ""
End If
End Sub
'----------------------------
"mattguerilla" a écrit dans le
message de news: ...
Hi,

How do I prevent someone copying data from cells in excel? I am using
excel
2000.

regards,

Matt

Just to add to Arvi's response.

Excel's security isn't made for this kind of protection.

You could try implementing the code that Ardus supplied, but if the user
disables macros or even resets his toolbar, then your data can be copied.



mattguerilla wrote:

Hi,

How do I prevent someone copying data from cells in excel? I am using excel
2000.

regards,

Matt

--

Dave Peterson