Hi all
I am trying to get list of all Custom functions with their syntax in the excel sheet.
because some of you are even facing the same problem that many a times we put the custom function in our workbook & get it protected but as we are not familiar with them we have to open the protected file & get the same through VBA code or go to function wizard to get the same.
is there is any other method specially VBA which runs a loop in all open workbook & get the function name with their syntax in activesheet.

say function = myfunction (tval as variant, testrange as range) as variant

like wise.
Hope u got my query.