Excel - Why Vba Udf Won'T Work In Personal Macro Workbook - Episode 1385

[@Ticky66MN]

Wow, that was amazing. You come up with some very creative solutions!! Thanks Bill

[@excelisfun]

That is an awesome tip!!!
I second, Bill for President!!!

[@riclopOC]

Bill for President. Most helpful. Thanks.

[@b-d-t]

Thanks for sharing this Bill. I wouldn't have thought to save it as an add-in, but this provides functionality for which I've been looking.

[@stephanrodriguez6587]

Awesome tips! I wish I found this before hours of research!

[@rishikeshsansare1061]

Thanks you Sir

[@b-d-t]

Never mind. I "repaired" Office 2010 by going through the Control Panel > Programs. After rebooting my computer, everything is back to normal.

[@b-d-t]

Hmm... After following your steps (and inserting a PERSONAL.xlsb file for my sub procedures), all my Excel file icons reverted to the Excel 2002 icon. This occurred in my Windows folders, and in my "Recent" files within Excel (I still have 2002 on my PC). Doubleclicking opens .xlsx files in Excel 2010, but if I choose "Open With," Excel 2002 is my only option and I cannot select Excel.exe from the Office 14 directory. Any thoughts?

[@robertlohman8947]

Mr Excel. I have tried this trick over and over but when I try to use the function, I get the error #NAME? The function I am trying to put in Add-in folder is
Function ShowFormula(MyCell As Range)
ShowFormula = MyCell.Formula
End Function
Please help ! By the way, there is a street in Apple Valley, California named "JELEN"