ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Disabling Function Results in the Function Arguments Window (https://www.excelbanter.com/excel-programming/417504-disabling-function-results-function-arguments-window.html)

[email protected]

Disabling Function Results in the Function Arguments Window
 
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?

Héctor Miguel

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.




All times are GMT +1. The time now is 06:14 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com