Worksheet.Protection generates error code 1004

This is code I have used in similar situations many times before, without problems.

However, the statement

Please Login or Register  to view this content.

now generates the general error 1004. The context is shown below.

Please Login or Register  to view this content.

Curiously, if I substitute

Please Login or Register  to view this content.

the code proceeds without hindrance, but that isn't really a suitable work around.

Advice please.

It seems that the VBA code for .Protection.AllowEditRanges(0) has changed since I last used it. AllowEditRanges.Add is now a method in its own right and some parameters must be stipulated. These are outlined as AllowEditRanges.Add method (Excel). These are new to me and appear to have been added in early 2019.

However, I noted another criterion in the form of .AllowInsertingHyperlinks. These permitted the revision of my code, which worked as expected. The code is shown below.

Please Login or Register  to view this content.