Hi,

You have a problem - you want to give people a file but you don't want them
to be able to use the information in it. The only true solution - send them
a dummy file with a place for them to put the info you want, when they return
the file put that info in your file.

If you let them have the file they can always copy the data one way or
another. 1. Passwords can be broken! You can download an Excel password
cracker program off the internet, and so can they! 2. Sheet protection
doesn't stop people from copying the sheet's data to a new workbook where
there will be no password. 3. They can always send you a copy of the file
they save and keep a copy on their systems, you can't stop that. 4. Even if
you figure solutions to the above - they can always use a screen capture
program to copy the data.

So back to the solution - send them a input template file with none of your
sensitive info in it, when its returned incorporate it into your files.

If this helps, please click the Yes button.

"th" wrote:

Every month i need to send a payroll excel workbk to different country
manager via attachment in email for them to update information in one of the
column in the workbook.
I have saved my workbook with password and with protection on worksheet.
But how do I ensure that this excel file that the country manager gets can
only open to update that specific column that i unprotect and save back in
the same file name.
Ie. how can i disable the save as (another filename) & copy command, so they
don't save it as another filename and make changes or use the highlight and
copy to copy and paste it to another new workbook to save?