Protection and Copying

[Bill Noonan]

I would like to password protect a worksheet. I think I
have the settings correct, but anyone can copy and paste
the range of cells and paste to another Worksheet...when
they do this all protection is lost. Am I missing some
setting?

Thnaks in advance.

 

[J.E. McGimpsey]

Not really, though, if you format your formula cells as hidden as
well as locked, a copy and paste will paste only the value, not the
formula.

OTOH, you might want to take a look at

http://www.mcgimpsey.com/excel/removepwords.html

for an explanation as to why Sheet protection should only be used to
prevent inadvertent changes, not for any real security.