Prevent users from copying worksheets

L

LISACOMOP

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!
 
T

Trimmer

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
 
H

Harald Staff

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
 
M

Michael

Hi Lisacomop. As a favor to the rest of us, please lose the caps. It's
shouting in these posts.
 
Top