i created a public function in a module. when i call it in excel, it
works fine. but as soon as i open any other workbook (even a new one),
it returns a value error. i have to go back into that cell and hit
enter for it to work again.

thoughts?

thanks,
sg