I've created a public function but cant use it because its not in the drop
down list of functions under user defined, am I missing something. thanks a
lot everyone
--
delmac

Did you create them in a standard code module, and not declare them Private,
and don't make the module Option Private?

--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)

"delmac" wrote in message
...
I've created a public function but cant use it because its not in the drop
down list of functions under user defined, am I missing something. thanks
a
lot everyone
--
delmac