How to copy formulas from a hidden sheet?

[claudio.gutierrez.m]

Hi all
I received a locked spreadsheet (of course, no password provided) and I want to copy the formulas that are in a hidden sheet. I can do "=hiddensheet!a1" to copy values but I need the formulas. Do you know some way to do that without going VBA?

Thanks

[daffodil11]

You can use Excel4 Macros which are still included, just not detailed.

GET.CELL parameters

Go to Formulas -> Name Manager
Define a New Name
Choose a Phrase like Cell_Formula
Define it as =GET.CELL(6,INDIRECT("hiddensheet!"&"RC",FALSE))

Now, in A1 on your sheet put =Cell_Formula and it will pull HiddenSheet!A1's formula.

[Tony Valko]

You may be interested in this:

https://www.excelforum.com/showthread.php?p=3847562

[claudio.gutierrez.m]

Thanks for your answers but Name Manager is not accesible (it is grayed out).
Any other suggestion?

Sent from my SM-G900M using Tapatalk