User Defined Function does not appear on Function listing

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

H.P.Hoeie, Norway - 21 Mar 2006 11:04 GMT

I've made two simple funtions, had no error messages. The functions are
restricted to the specific work sheet where they were made.
When I want to try them in a work sheet, they do not appear. Usually this
sequence works: Insert/Function/User Defined. But it does not appear there.

Reply to this Message

Niek Otten - 21 Mar 2006 11:27 GMT

You should put the functions in a standard module, not a sheet module

Signature

Kind regards,

Niek Otten

> I've made two simple funtions, had no error messages. The functions are
> restricted to the specific work sheet where they were made.
> When I want to try them in a work sheet, they do not appear. Usually this
> sequence works: Insert/Function/User Defined. But it does not appear there.

Reply to this Message