View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
TH TH is offline
external usenet poster
 
Posts: 3
Default 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?