 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
| HomeDiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWordDirectoryUser Groups Related Topics Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ... |
MS Office Forum / Excel / New Users / April 2004Protect Worksheet method fails - Spanish
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 You may want to post the portion of code that's causing the trouble. > I have solutions developed in English Windows (2000 pro) and English > Office (2000 pro) which fail on a Spanish version of Windows and [quoted text clipped - 11 lines] > > Matt  SignatureDave Peterson ec35720@msn.com 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 > You may want to post the portion of code that's causing the trouble. > [quoted text clipped - 13 lines] > > > > 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 > You may want to post the portion of code that's causing the trouble. > [quoted text clipped - 13 lines] > > > > 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. > Hi Dave, > [quoted text clipped - 32 lines] > > > > > > Matt SignatureDave Peterson ec35720@msn.com |
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2008 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.