I don't think so.

Anything that I would come up with would depend on macros and macros can be
disabled.

th wrote:

I have already save the file with password and protect the sheet (only open 1
column for edit). Is there anyway to put a marco within the worksheet to
disable the copy and save as command? So whenever the country manager
receive this workbook, they won't be able to use the save as and copy command.

"Satti Charvak" wrote:

Well you can share the pass word with the people you want to share the data
reliably.

Also, if you protect the sheet completely, without allowing to edit any of
the cell, it becomes very difficult to copy.

Evenmore, you can also put any password for opening the file.

--
Kind Regards,
Satti Charvak
Only an Excel Enthusiast
Noida, India


"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?

--

Dave Peterson