K
kensanjose
yet allow users to select values in a defined range
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
D
dominicb
Good evening kensanjose
You really need to supply more information about what you mean - cop
the file/sheets/ranges etc
Dominic
You really need to supply more information about what you mean - cop
the file/sheets/ranges etc
Dominic
K
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
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
D
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
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
D
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.
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.