Is there a way to write a macro to save over a write protected file which I know the password for? Alternatively, can i simply disable the write protection on the file with the macro before saving it to another file name?
My situation is that we have a file which is updated daily but is a monthly workbook. This file must be write protected. At the end of every month, some changes need to be made with a macro and then it needs to be saved to an archive folder before it is cleared for the next month. This would not be a problem for the first year. However, the second year, when the files for each month already exist (i suppose if I can't solve this I can just remove them yearly) I will get an error that says I can't save over the file because it is write protected. I only get this error when saving through the macro and do not get it if I save manually.
I was thinking that if I can't do that, then perhaps I could disable the write protection with a macro and then save it to the archive folder so none of the archived files will be right protected. This is certainly the less optimal option.
Bookmarks