vba excel - public function in module

[g.sarika]

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

 

[Gaurav Kothari]

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