+ Reply to Thread
Results 1 to 4 of 4

VBA Macros not working after copying from German version to English one

  1. #1
    Forum Contributor
    Join Date
    07-22-2013
    Location
    Sibiu
    MS-Off Ver
    Excel 2007
    Posts
    114

    VBA Macros not working after copying from German version to English one

    Basicly all I did was to copy a file from a German excel to and English license and the workbook doesnt want to work properly. I get these errors "-2147319784
    Method "unprotect" of object worksheet has failed." and "Method "activate" of object worksheet has failed.". I have translated all german letters i have checkes makro security and references.. everything seems to be ok but of course it seems that I am missing something. I would appreciate any help. Thank you in advance.

  2. #2
    Valued Forum Contributor
    Join Date
    03-29-2013
    Location
    United Kingdom
    MS-Off Ver
    Office/Excel 2013
    Posts
    1,749

    Re: VBA Macros not working after copying from German version to English one

    Unprotecting and activating a worksheet is simple enough... You'll probably find the password and worksheet name didn't quite translate or something but you'll need to go into debug mode to find out.
    In debug hover the cursor over each variable and the popup will tell you it's value - that's where you'll find your problem
    Elegant Simplicity............. Not Always

  3. #3
    Forum Contributor
    Join Date
    07-22-2013
    Location
    Sibiu
    MS-Off Ver
    Excel 2007
    Posts
    114

    Re: VBA Macros not working after copying from German version to English one

    I have translated all the necesary information , like worksheet name, so i dont think it has to do with reading the information but more about a setting on the english license.. maybe there is something that i need to change to a library or i dont know, but i will give it a try and see if it works. ny other sugestion would be welcomed.

  4. #4
    Forum Contributor
    Join Date
    07-22-2013
    Location
    Sibiu
    MS-Off Ver
    Excel 2007
    Posts
    114

    Re: VBA Macros not working after copying from German version to English one

    Have tried everything ... still the same things .. has anyone ever copied a file from one language to another and had problems with it?

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Sheet created on German version of excel, TEXT function doesn't work in English
    By brum17 in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 04-18-2011, 09:03 AM
  2. German language issues with macros - Office 2003 version
    By Colinhp in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 07-28-2006, 10:00 AM
  3. Trouble with german / english dateformatting
    By Alex in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 10-05-2005, 11:05 AM
  4. Macros from German excel don't work with English version
    By Klaus Heinrich in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 09-25-2005, 01:05 PM
  5. [SOLVED] How do I run Spanish macros in an English version?
    By Jaime Y. in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 09-02-2005, 05:05 AM

Tags for this Thread

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1