Protect Worksheet method fails - Spanish

  • Thread starter Thread starter Matt
  • Start date Start date
M

Matt

I have solutions developed in English Windows (2000 pro) and English
Office (2000 pro) which fail on a Spanish version of Windows and
Office while using the Protect method. The following error is
displayed:

Se ha producidoel error '1004' en tiempo de ejecución :

Fallo en el método Protect de la clase Worksheet.

I believe it to be a problem with the internationalisation of Office,
but is there a workaround?

Thanks

Matt
 
Hi Dave,

I have not been able to replicate the problem on English XP and
Spanish Office, so I'm not exactly certain of the line, and as the
module is protected, I can't get the user to tell me what it is
either, but anyway, I believe the line is:

Sheets(1).Protect Password:= "Password", _
DrawingObjects:=False, Contents:=False

I know someone in Mexico had the same problem posted on this usenet,
but there were no replies. (Subject: Duda de macro para proteger hoja
de calculo)

Any suggestions would be appreciated!

Thanks
Matt
 
Hi Dave,

I have not been able to replicate the problem on English XP and
Spanish Office, so I'm not exactly certain of the line, and as the
module is protected, I can't get the user to tell me what it is
either, but anyway, I believe the line is:

Sheets(1).Protect Password:= "Password", _
DrawingObjects:=False, Contents:=False

I know someone in Mexico had the same problem posted on this usenet,
but there were no replies. (Subject: Duda de macro para proteger hoja
de calculo)

Any suggestions would be appreciated!

Thanks
Matt
 
I'm not sure I can help.

And with the code protected, there's not much you can do even if you know the
problem (as far as I can see).

Are you the developer? If yes, then if it were me, I'd share a copy of the
unprotected workbook with the user. (maybe breaking it enough so that it's not
useful). Then let them tell me the broken stuff.
 
Back
Top