#NAME Error with Function Defined with Public Function

[Simon Austin]

Hi All.

I've defined a function to display the Category from properties as follows:

Please Login or Register  to view this content.

I've put a formula into a worksheet to display this value (in this case the version number) which is

Please Login or Register  to view this content.

This works fine on my laptop, however if anyone else views the file they get a #NAME error in the cell where the formula is. I was thinking that perhaps the code needed to be loaded when the file opens, can anyone advise how this would be done as using the public function with workbook_open doesn't seem to work. Ant other suggestions also welcome of course.

Thanks

Simon

[romperstomper]

Where did you put the code? In the workbook, or in another workbook such as your personal macro workbook? If it's in the workbook, then it may be that the others simply have macros disabled.