Dear all,
I would like to ask you to help me with a vba code as I am unsure how to do it.
I would like to have a macro that - in this order -

folder path: C:\Users\thoandros\Desktop

1) saves the current file (filenname: abc.xlsx) with a password "dcba" to open
2) saves a copy of the file with a different name (filename: generalABC.xlsx) and protects with the password "abcd" to edit

The point is that the generalABC is a file other people opens on their computer as read-only and keeps it open for hours and therefore I am not sure the macro can save the file, if already open by another user. So if that is the case, I would like the macro to save it, still in the same folder as "temp_generalABC.xlsx" and alert me with a text box that this happened, so I remember at some point to go and rename the file.

Thank you in advance to anyone that can help me