Cant find my Excel function, help please

[KAISSAH]

Guys, im using an old spreadsheet but it had like a custom Macro or Function but I cant see it, how can I call it? I think it was with a function key?

Are they stored in another file?

Any hints please?


Regards,

Christian Gutierrez

[hrlngrv]

By function, so you mean a user-defined function used in cell formulas? If so, they could have been in .XLA, .XLAM or .XLL add-ins in addition to the workbook itself.

If you mean a macro, it could have been in GLOBAL.XLS, PERSONAL.XLS, PERSONAL.XLSM or PERSONAL.XLSB in addition to the workbook itself.

You can press [Alt]+[F11] to display the Visual Basic Editor. Does that show any modules for your old workbook? Does it show any sheets which don't appear in the worksheet tabs? It's possible you have an XLM macro sheet if the workbook is really old.

[KAISSAH]

Thank you very much for your reply.

Yea, I by mistake wiped out my hard drive and apparently the macro file got lost in the process, I was able to find the main file only.

I will try to look for my older posts since I got helped here back then, and from there I will try to recreate it.

Again, thanks a bunch and till next time!

Regards,

Christian Gutierrez