Home |
Search |
Today's Posts |
#1
|
|||
|
|||
how do I prevent a worksheet from being copied in excel
yet allow users to select values in a defined range
|
#2
|
|||
|
|||
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 |
#3
|
|||
|
|||
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 |
#4
|
|||
|
|||
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 -- dominicb ------------------------------------------------------------------------ dominicb's Profile: http://www.excelforum.com/member.php...o&userid=18932 View this thread: http://www.excelforum.com/showthread...hreadid=385319 |
#5
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
prevent saving a worksheet | Excel Discussion (Misc queries) | |||
how to prevent worksheet scroll bar to be bigger than working are. | Excel Worksheet Functions | |||
Prevent unhide of rows/columns w/out worksheet protection? | Excel Discussion (Misc queries) | |||
can you prevent viewing of specific columns in a worksheet | Excel Worksheet Functions | |||
URGENT Please... new worksheet with copied formats but no data. | Excel Worksheet Functions |