I have an question relating to Excel protection. I know that I can set a password to OPEN and a separate password to EDIT. However is there a way to prevent recipients from opening as read only (they will have been provided with the password to open only) and then saving locally as a separate new spreadsheet without any password at all?
The Excel file is distributed to recipients by email for their information and although they should not really need to amend or edit in any way, it would be safer - with reference to new data protection legislation - for copying to be barred.
Any help would be appreciated.
Thanks in advance