Workbook Saved with ReadOnly - need that removed

[ImaCoolClassic]

I have a macro workbook that one of the functions is to go thru a list of members and create a copy of the "Master" workbook.

These workbooks (and the Master too) when a user goes to open them always receive the Read Only which is forcing them to save as a different name and then rename their workbook back to the original name. I am using this code....

If Sheets("ManageFiles").Cells(x, 3).Value <> "" Then
ActiveWorkbook.SaveCopyAs WbPath & Sheets("ManageFiles").Cells(x, 3).Value
DoEvents
End If

I've tried changing settings on the workbook but still to no avail.

The workbooks (Master and created copies) do not have the read only flag checked either.

The files are being saved to a Network location which does have the correct authorizations.

TIA

 

[JackDanIce]

Welcome to the board. Try using SaveAs:

If Sheets("ManageFiles").Cells(x, 3).Value <> "" Then
    ActiveWorkbook.SaveAs WbPath & Sheets("ManageFiles").Cells(x, 3).Value
    DoEvents
End If