Forum Discussion
Kami-1
Feb 14, 2021Copper Contributor
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_LewinSilver Contributor
- Kami-1Copper Contributor
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.