VBA Function to calculate totals - Problem with multiple workbooks

[Hood]

I have the code below in a module that works fine except for one problem.
If I open another workbook (different name) that has the same code, it recalculates the first workbook to match the numbers of the second workbook that is opened.
I need the code specific to each individual workbook, but I am not sure how. Any help is appreciated!

Please Login or Register  to view this content.

[tehneXus]

try

Please Login or Register  to view this content.

[Hood]

Thank You!