My Code For Protecting Isn't working

[mingauhauck]

I'm trying to make it work:

But for some reason it's not working. There is a 1004 error at:

Please Login or Register  to view this content.

And the button are not working either. Even if i cancel the protection and unprotection functions.

Don't know what it's happening.

Please Login or Register  to view this content.

[vba_php]

1004 is application defined or object defined error. with the method you are using, it could be any number of things. VBA isn't the greatest languages in the world, and is completely inconsistent in many ways. MS's fault, totally. see these first:

https://www.google.com/search?q=excel+vba+.Protect+

https://docs.microsoft.com/en-us/off...ksheet.protect

https://www.google.com/search?q=vba+excel+1004+error

https://stackoverflow.com/questions/...or-when-select

then, maybe try all of the following as possible fixes

Sheets("Formulario de Nova Contratacao").Protect Password:="3,1415", DrawingObjects:=-1, Contents:=-1, Scenario:=-1 

Sheets("Formulario de Nova Contratacao").Protect Password:="3,1415", True, True, True 

Sheets("Formulario de Nova Contratacao").Protect "3,1415", True, True, True 

furthermore, are you sure the code is the issue? If there is no sheet called Formulario de Nova Contratacao, that would also cause the error, obviously. no defined object in that case.

[Andy Pope]

The named argument is Scenarios, plural.

Please Login or Register  to view this content.

[vba_php]

wow. nice catch andy!