Hi,

Would this work ?

Code:
Dim NewBookX As Workbook
Set NewBookX = Workbooks.Add

If NewBookX.ReadOnly Then
    NewBookX.ChangeFileAccess Mode:=xlReadWrite
    NewBookX.Name = "NewName"
End If