I have a macro (made for Excel - Windows), which url encode strings - i.e. space becomes %20. When I open the *.xlsm on a Mac with Excel installed(Office for Mac 2011), it does not work. No errors - nothing!! I found this from googling - http://blog.mclaughlinsoftware.com/2010/11/04/excel-2011-without-udfs/ I have tried re-installing as described in the link above with no success. I can not even get the small "tests" to work as described.
Function hello() hello = "Hello World!" End Function Function hellowhom(nameIn As Variant) hellowhom = "Hello " + CStr(nameIn) + "!" End Function
=hellowhom(A1) in the formula builder.
Any hints or tips??