ActiveWorkbook.SaveCopyAs with conditions

Hi all,

I have a workbook that anyone can view as read-only but requires a password to modify. Currently, I have the following happen when the workbook is closed;


This works just fine and saves a copy. What I am looking to do is only get the workbook to create a copy if the Modify password is entered i.e. the administrator has opened the sheet and not just every one viewing.

Thanks in advance

You could try (untested):

Thanks p45cal, will give it a bash