View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Héctor Miguel Héctor Miguel is offline
external usenet poster
 
Posts: 434
Default Disabling Function Results in the Function Arguments Window

hi, john !

I have written user defined functions that are passing matrices as arguements
and would like to disable the function results in the function arguement window.
Any suggestions?


a wild idea is valid ?

make your udf a private function procedure (so it won't appear in the function-wizard dialog)
and *call* for it knowing that *there it is* (you shall provide the *known* arguments)

also, note that you won't be able to paste it's arguments in formula-bar (ctrl+shift+A)

hth,
hector.