Feb 14 2021 12:47 PM
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
Feb 14 2021 01:07 PM
The English codewords should work in any language.
=ZELLE("Contents";A1)
=CELL("Contents";A1)
Feb 17 2021 08:10 AM
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.