i have an addin that load automatically each time i open excel and it's full of subs that i use regularly and they work fine. i recently tried to add a function to one of the modules in the .xla file and when i'm in a spreadsheet, it won't work. if i move the function to a module specific to the sheet i'm in, no problems, but i would like to be able to include it in my .xla file.
any help in this area would be appreciated.
THANKS
any help in this area would be appreciated.
THANKS