Different Workbooks interfering with each other

[mwollert]

I am suddenly having a strange problem. I open a workbook that has cells calculated with a function call in VBA. The workbook works fine when it is the only one open. When I open another workbook that also has some cells calculated with function calls in VBA, the first workbook changes all cells that were calculated with a function to #value. I go to that workbook and press CNTL-ALT-F9 and the values come back but then all cells calculated with functions go to 0 on the other workbook.

The functions are not the same name and both are contained in a module saved within each workbook. The functions do the same thing (they calculate income tax) but I changed the names thinking they were conflicting with each other and still only 1 sheet at a time will display the cells that use a function to calculate the values.

Seems to be a fairly recent problem as they have been opened together in the past and did not conflict with one another. Not sure what I changed to cause the confliction.

Any suggestions?

[scottiex]

I think you will need to post the code, or even better the sheets.

[mwollert]

The code for both functions is :

Please Login or Register  to view this content.

I changed the name in the second workbook to rTaxCalculate

[Norie]

Your post does not comply with Rule 3 of our Forum RULES. Use code tags around code.

Posting code between [CODE]Please [url=https://www.excelforum.com/login.php]Login or Register [/url] to view this content.[/CODE] tags makes your code much easier to read and copy for testing, it also maintains VBA formatting.

Click on Edit to open your thread, then highlight your code and click the # icon at the top of your post window. More information about these and other tags can be found here

(This thread should receive no further responses until this moderation request is fulfilled, as per Forum Rule 7)

[scottiex]

Looks like you added the code tags so I presume I can post.

The code seems to work for me (in two books) - I don't think you should need to change the second workbook's function name, maybe you made a mistake doing that or there is some other issue with your workbooks that we cannot see.

You could try putting the macro in a personal workbook or similar instead.