File Protection with Save as & Copy option disable
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?
|