Need to Prevent a protected sheet from being copied?!?

S

shan

I have a spread sheet that contains sensitive pricing details not to b
viewed by the users, but needed due to being referenced in variou
equations.
This file is to be used by multiple persons who will get this vi
email, and then enter data into unlocked cells in order to get a fina
'price'.

I have protected both the sheets and the workbook.
BUT I can still hilight and copy individual protected sheets and the
paste them into a new workbook at which point it is completel
unprotected.
Ultimately I need to email this to others.
Is there a way to prevent this copying and pasting?

Thanks
 
J

Jason Morin

Excel's security features can easily be bypassed (as
you've seen) and should not be relied upon to protect
sensitive information when sent to another party.

HTH
Jason
Atlanta, GA
 
Top