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!

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!

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!

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!