-
Solved: Get functions list in Worksheet
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.
Always Mark your Thread as Solved the moment u got acceptable reply (located under Thread tools)
Practice this & save time of others in thinking for unsolved thread
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules