Different languages collision in one function.

%3CLINGO-SUB%20id%3D%22lingo-sub-2134202%22%20slang%3D%22en-US%22%3EDifferent%20languages%20collision%20in%20one%20function.%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2134202%22%20slang%3D%22en-US%22%3E%3CP%3EHello%2C%3C%2FP%3E%3CP%3EI%20have%20to%20work%20with%20protected%20document%20without%20macros%20and%20I%20can%20not%20find%20its%20author.%3C%2FP%3E%3CP%3EIt%20is%20created%20in%20German%20language%2C%20but%20I%20want%20to%20open%20document%20and%20edit%20with%20my%20language.%3C%2FP%3E%3CP%3EThere%20is%20an%20original%20formula%20in%20locked%20cell%3C%2FP%3E%3CP%3E%3DZELLE(%22Inhalt%22%3BA1)%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EWhen%20I%20open%20it%20with%20English%20default%20language%2C%20the%20parameter%20of%20function%20remains%20in%20German%3C%2FP%3E%3CP%3E%3DCELL(%22Inhalt%22%3BA1)%3C%2FP%3E%3CP%3EBut%20it%20should%20be%3C%2FP%3E%3CP%3E%3DCELL(%22Contents%22%3BA1)%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EIs%20any%20way%20how%20to%20fix%20it%3F%3C%2FP%3E%3CP%3EIs%20any%20possibility%20to%20change%20%22CELL%22%20function%20definition%20using%20VBA%20without%20changing%20the%20document%3F%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThanks%20for%20reply%3C%2FP%3E%3CP%3EKamil%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2134202%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2134263%22%20slang%3D%22en-US%22%3ERe%3A%20Different%20languages%20collision%20in%20one%20function.%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2134263%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F966451%22%20target%3D%22_blank%22%3E%40Kami-1%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThe%20English%20codewords%20should%20work%20in%20any%20language.%3C%2FP%3E%3CPRE%20class%3D%22lia-code-sample%20language-applescript%22%3E%3CCODE%3E%3DZELLE(%22Contents%22%3BA1)%0A%3DCELL(%22Contents%22%3BA1)%3C%2FCODE%3E%3C%2FPRE%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2143331%22%20slang%3D%22en-US%22%3ERe%3A%20Different%20languages%20collision%20in%20one%20function.%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2143331%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F1639%22%20target%3D%22_blank%22%3E%40Detlef%20Lewin%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThank%20you%20for%20your%20advice.%3C%2FP%3E%3CP%3EI%20tried%20it%20and%20it%20works%2C%20but%20problem%20is%20I%20can%20not%20unlock%20the%20original%20sheet%20so%20I%20can%20not%20fix%20it%20this%20way.%3C%2FP%3E%3C%2FLINGO-BODY%3E
New Contributor

Hello,

I have to work with protected document without macros and I can not find its author.

It is created in German language, but I want to open document and edit with my language.

There is an original formula in locked cell

=ZELLE("Inhalt";A1)

 

When I open it with English default language, the parameter of function remains in German

=CELL("Inhalt";A1)

But it should be

=CELL("Contents";A1)

 

Is any way how to fix it?

Is any possibility to change "CELL" function definition using VBA without changing the document?

 

Thanks for reply

Kamil

 

 

2 Replies

@Kami-1 

The English codewords should work in any language.

=ZELLE("Contents";A1)
=CELL("Contents";A1)

@Detlef Lewin 

Thank you for your advice.

I tried it and it works, but problem is I can not unlock the original sheet so I can not fix it this way.