excel vba - protect sheet so no copy/paste ability

C

chief

I have set up my sheet to protect using a password name login which the
runs the macros. It is set up so that the sheet's cells cannot b
edited, but the person can copy/paste the info onto another sheet.
This is a problem because there are hidden cells which contai
sensitive data. Any ideas
 
S

Sean

Hi, just a comment that i just found out, check out this
link that I was refered too. That password that you
setup doesn't do squat when you have access to this...
http://www.straxx.com/excel/password.html
I was mad when I saw this, when means nothing is really
safe unless you have a rookie looking at the spreadsheet.
THanks
Sean
 
Top