activate custom function in VBA (Xl'97)

Hello

I have converted a XL'95 sheet into 97.

But in XL'97 the user functions are not getting activated. So the cells referring to these functions give a error message.

However if i make a small modification in the macro and then click F9(key for recalculation), the user functions are accessed properly.

If u have solved similar problem please let me know

Thanks in advance

Ratna