Why this 1004 Error message?

[Stuart]

A simple routine which starts as:

With ActiveWorkbook.Worksheets("Master CVI")
.Unprotect Password:="SGB"
.Cells.Locked = False

(code now works with just this sheet, and finally
protects it, before closing the With statement)

'Protect the sheet
.Protect Password:="SGB"
.EnableSelection = xlUnlockedCells
End With

I now immediately say:

'Protect the workboook
ActiveWorkbook.Protect Password:="SGB"

End Sub

and it's on this last line that the error is raised.

Why so, please?

Regards.

 

[Dave Peterson]

I could get a 1004 error message if the workbook were already protected with a
different password.

 

[Stuart]

That was my error.

Regards and thanks.

I could get a 1004 error message if the workbook were already protected with a
different password.