Also make sure it is in a general module and not a sheet module or other
special module like workbook or userform or a class module. You get a
general module when you go the vbe and with personal.xls as the active
project, do Insert = Module.

when you declare the function make it public

Public Function FractionChange(rng1 as Range, rng2 as Range)

End Function


--
Regards,
Tom Ogilvy

"rleonard" wrote in message
...
Tushar,

I put code in a module Personal.xls as Option Explicit! But when I open
another worksheet i can not find function FractionChange! How can i fix this
so function is available to all my worksheets!

Thanks
Bob Leonard