disabling the copy and paste

  • Thread starter Thread starter Marius61
  • Start date Start date
M

Marius61

I would like to know if it is possible to disable the copy and paste of an
EXCEL sheet content.

In other words I would like to protect the contents of a sheet.

Could you please give me an example about how to do this?

Thanks a lot to all in advance
Marius61
 
You can go to the tools menu and select protection and set
a password. Your spreadsheet will not be changed unless
someone knows the password.

but if your concern is someone will copy the entire sheet
or a section and paste it to a new sheet, then they would
have access to your formulas etc.

the newest version of excel (beta 2 2003)maybe not
released yet has a way to lock cells so a user can not
even select them without a password. This will prevent
anyone from copy/paste.

I hope this helps

Rick
 
It's virtually impossible to disable copy/paste. Although
there are some options that can prevent copying, simply
disabling macros will bypass this. Copying from Excel
into another app, or another instance of Excel can easily
be done too, and there are no options I know of to prevent
this.

The best I can think of is add this to your workbook's
event module to prevent copying from one worksheet into
another in the same book, and from one workbook into
another.

Private Sub Workbook_SheetDeactivate(ByVal Sh As Object)
Application.CutCopyMode = False
End Sub

Private Sub Workbook_WindowDeactivate(ByVal Wn As Window)
Application.CutCopyMode = False
End Sub
 
Back
Top