Very Elementary VBA question

[CptNemo]

Hi All,

I'm teaching myself very basic macro-writing as I try and develop them into Excel models. I wrote an extremely easy Select...case function and it works fine within the worksheet it was created in. However, if I were to copy that worksheet's tab over to a new worksheet, the function no longer. I'm assuming that that is because that specific worksheet doesn't recognize the code, so I have been copying over the original worksheet's modules into the new worksheets. This seems like something I can fix with a simple declaration, but I don't know what that declaration would be. I also copied the macro's code into the Personal.XLS module, thinking that would make the function universal, but now in order to call up the function in Excel, I would have to write =Personal.XLS!functionname, or something like that.

I would appreciate any help making my function a "universal" function that would automatically be associated with that specific tab, no matter where it is copied. Thank you very much, I'm sorry for the basic question.

Jan