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

In order to use function globaly to other workbook, you had to make
Addin......

Follow this :
- Create new Excel file
- Write your code(function)
- Save file as Excel Add-in (.xla file).
.....now, Go to Tools -- Addins... and load the saved file.

now this The function will now be globally available to all.

will not work if moved to a different machine, as it a different case.......:)

Gaurav Kothari


" wrote:

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