how do I prevent a worksheet from being copied in excel

[kensanjose]

yet allow users to select values in a defined range

[dominicb]

Good evening kensanjose

You really need to supply more information about what you mean - copy the file/sheets/ranges etc

DominicB

[kensanjose]

How do I prevent a worksheet from being copied in excel? Can I disable right
click within a file so that the sheet cannot be copied into another file and
manipulated? I want to give another user acccess to a specificed range in the
worksheet yet prevent them from changing the structure of the worksheet. In
short they should be able to only select values within cells, but should not
be able to compromise the integrity of the worksheet by copying and editing
into a separate worksheet

"dominicb" wrote:

>
> Good evening kensanjose
>
> You really need to supply more information about what you mean - copy
> the file/sheets/ranges etc
>
> DominicB
>
>
> --
> dominicb
> ------------------------------------------------------------------------
> dominicb's Profile: http://www.excelforum.com/member.php...o&userid=18932
> View this thread: http://www.excelforum.com/showthread...hreadid=385319
>
>

[dominicb]

Good morning Kensanjose

You can achieve part of what you need to do. Use Tools > Protection > Protect Sheet to apply the protection. Prior to doing this select the cells that people are going to be able to edit and hit ctrl + 1. Go to the protection tab and uncheck the locked box.

You can disable the right click event by inserting this code into the ThisWorkbook pane of the VBE:

Private Sub Workbook_SheetBeforeRightClick(ByVal Sh As Object, _
ByVal Target As Range, Cancel As Boolean)
Cancel = True
End Sub

However, users will still be able to copy a workbook through the menu Edit > Move or Copy Sheet (use Tools > Protection > Protect Workbook to prevent this) and keyboard shortcuts. As such it is very difficult to stop users from doing a whole range of things, and impossible to control a worksheet so tightly that a determined person cannot circumnavigate.

HTH

DominicB

[Dave Peterson]

I don't think you can stop the determined user.

Any suggestion I would give would depend on macros. Macros can be disabled by
the user whenever they open the workbook.

Heck, the user could even just copy the file using windows explorer.

kensanjose wrote:
>
> How do I prevent a worksheet from being copied in excel? Can I disable right
> click within a file so that the sheet cannot be copied into another file and
> manipulated? I want to give another user acccess to a specificed range in the
> worksheet yet prevent them from changing the structure of the worksheet. In
> short they should be able to only select values within cells, but should not
> be able to compromise the integrity of the worksheet by copying and editing
> into a separate worksheet
>
> "dominicb" wrote:
>
> >
> > Good evening kensanjose
> >
> > You really need to supply more information about what you mean - copy
> > the file/sheets/ranges etc
> >
> > DominicB
> >
> >
> > --
> > dominicb
> > ------------------------------------------------------------------------
> > dominicb's Profile: http://www.excelforum.com/member.php...o&userid=18932
> > View this thread: http://www.excelforum.com/showthread...hreadid=385319
> >
> >

--

Dave Peterson