Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Prevent users from copying worksheets
CAN'T SEEM TO PREVENT USERS FROM COPYING A PROTECTED WORKSHEET AND THEREFORE
UNPROTECTING IT AND HAVING ACCESS TO EVERYTHING ON THE WORKSHEET. SOMEONE PLEASE HELP! |
#2
|
|||
|
|||
Excel 2003 has a much better protection control. I had people here trying to
do the same but nolonger get around the locks that way -- Trimmer "LISACOMOP" wrote: CAN'T SEEM TO PREVENT USERS FROM COPYING A PROTECTED WORKSHEET AND THEREFORE UNPROTECTING IT AND HAVING ACCESS TO EVERYTHING ON THE WORKSHEET. SOMEONE PLEASE HELP! |
#3
|
|||
|
|||
Hi
Select "Hidden" in addition to "Locked" when you protect your cells. Then Paste will paste the values instead of the underlying formulas. You can also fill the clipboard with nonsense using macros and events, if you can ensure that macros are enabled. HTH. Best wishes Harald "LISACOMOP" skrev i melding ... CAN'T SEEM TO PREVENT USERS FROM COPYING A PROTECTED WORKSHEET AND THEREFORE UNPROTECTING IT AND HAVING ACCESS TO EVERYTHING ON THE WORKSHEET. SOMEONE PLEASE HELP! |
#4
|
|||
|
|||
Hi Lisacomop. As a favor to the rest of us, please lose the caps. It's
shouting in these posts. -- Sincerely, Michael Colvin "LISACOMOP" wrote: CAN'T SEEM TO PREVENT USERS FROM COPYING A PROTECTED WORKSHEET AND THEREFORE UNPROTECTING IT AND HAVING ACCESS TO EVERYTHING ON THE WORKSHEET. SOMEONE PLEASE HELP! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
zero value when copying cells between worksheets | Excel Discussion (Misc queries) | |||
copying addresses from one workbook to another into several worksheets | Excel Worksheet Functions | |||
prevent users from overwriting other users data | Excel Worksheet Functions | |||
Protecting Workbook | Excel Discussion (Misc queries) | |||
copying cells from other worksheets | Excel Discussion (Misc queries) |