Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Prevent user from copying contents of a worksheet
Hi - Is there any way to prevent a user from copying the contents of a
worksheet? I don't want users copying anything into different worksheets that I have no control over. -- TIA Chuck M. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Prevent user from copying contents of a worksheet
Excel internal security is very weak and passwords easily cracked but you
might stop an unsophisticated user who could not figure out how to crack the passwords. Also see caveat in the last paragraph below before going to too much trouble to keep you work secure. Lock all the cells. Protect the worksheet with "allow users to select unlocked cells" disabled. Protect the workbook also to prevent copying the worksheet. But.................If the user is bright enough he could just open another workbook and link all your sheet's cells to a sheet in that one. Gord Dibben MS Excel MVP On Wed, 27 Aug 2008 13:15:01 -0700, Chuck M wrote: Hi - Is there any way to prevent a user from copying the contents of a worksheet? I don't want users copying anything into different worksheets that I have no control over. |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Prevent user from copying contents of a worksheet
Thanks Gord. There are already passwords on the worksheet and workbook and
cells with formulas are locked. However, there are cells where the user is allowed to input financial numbers therefore allowing users to select unlocked cells must be enabled. Guess I'll just have to live with the possiblity that users can copy the worksheet. Thanks for responding! --- Chuck M. "Gord Dibben" wrote: Excel internal security is very weak and passwords easily cracked but you might stop an unsophisticated user who could not figure out how to crack the passwords. Also see caveat in the last paragraph below before going to too much trouble to keep you work secure. Lock all the cells. Protect the worksheet with "allow users to select unlocked cells" disabled. Protect the workbook also to prevent copying the worksheet. But.................If the user is bright enough he could just open another workbook and link all your sheet's cells to a sheet in that one. Gord Dibben MS Excel MVP On Wed, 27 Aug 2008 13:15:01 -0700, Chuck M wrote: Hi - Is there any way to prevent a user from copying the contents of a worksheet? I don't want users copying anything into different worksheets that I have no control over. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Prevent user from using Name | Excel Discussion (Misc queries) | |||
How can user move in locked worksheet but not copy cell contents? | Excel Worksheet Functions | |||
How do I prevent cell contents from printing? | Excel Discussion (Misc queries) | |||
Prevent user from saving workbook | Excel Discussion (Misc queries) | |||
How to prevent user from printing in Excel? | Excel Discussion (Misc queries) |