public function

[tom mcdonald]

hi all, I've inserted a public function in a ordinary module calle
(bytereverse)
but when I try to insert it using the insert function its not ther
under user defined functions. Any tips on where I am going wrong
Thanks all

 

[Bob Phillips]

Are you looking in the User Defined Functions category?

--
HTH

Bob Phillips

"tom mcdonald" <[email protected]>
wrote in message
news:[email protected]...

 

[David McRitchie]

Hi Tom,
Nothing strikes a bell with me,

Don't know if you are using = in a cell before using Insert, Function
or the [fx] button, which gets the list and I think you say you see the list.

Did the module name begin with "Module" before you renamed it?

Is the workbook open? Is it hidden? Is it in your personal.xls?
Is it in the same workbook?

Does it work if you code it something similar to
=personal.xls!myfunction(A1)

You might check over
http://www.mvps.org/dmcritchie/excel/getstarted.htm
http://www.mvps.org/dmcritchie/excel/install.htm