Forum Discussion

Kami-1's avatar
Kami-1
Copper Contributor
Feb 14, 2021

Different languages collision in one function.

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

  • Detlef_Lewin's avatar
    Detlef_Lewin
    Silver Contributor

    Kami-1 

    The English codewords should work in any language.

    =ZELLE("Contents";A1)
    =CELL("Contents";A1)
    • Kami-1's avatar
      Kami-1
      Copper Contributor

      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.

Resources