I have a Workbook which is protected with a password. It dispalys the password entry box when opened allowing either the password to be entered or for the WorkBook to be opened as 'Read Only'.
Is there any way for the Workbook Password to be changed to a different pre-set password when the file is saved using a different name?
Example
Say the Workbook is called 'Company XYZ Working Report.xlsm' and has the password ABC123. If the file is saved using the same filename, the password remains the same, however if I save the Workbook using a different name, say 'Company XYZ Public Report.xlsm' is there any way that the password could be automatically set to be something different, e.g. XYZ456 without having to manually reset it?
So effectively the password is automatically set based on the file name?
Many thanks
Bookmarks