View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.interopoledde,microsoft.public.excel.programming,microsoft.public.excel.sdk
Aaron Queenan Aaron Queenan is offline
external usenet poster
 
Posts: 30
Default Registering function WITHOUT it appearing in the expression builder

Is there any way to use the Excel4 or COM interfaces to register a function
in an XLL without it appearing in the list from the expression builder?

I need to be able do some processing in a macro called from OnTime, but
OnTime pops up a message box at the appointed time complaining that it can't
find the macro 'CALL(a,b,c)' if I use a CALL expression. Registered
functions and VBA functions in a module work okay, but I don't want the user
to be able to see this function.

Thanks,
Aaron Queenan.