Protection and Copying

  • Thread starter Thread starter Bill Noonan
  • Start date Start date
B

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.
 
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.
 
Back
Top