Macro reverts to Function

[Ricardo9211]

I have a workbook with a macro that seems to run fine but then i added a sheet that required Functions in a module, now when i run my macro it calls the funtions and tries to run them as macros as well and locks up the workbook.
Has anyone run into this before and what do you do to get away from it

Thanks
Ricardo9211

[shg]

Pardon ...?

[Ricardo9211]

I have a work book that has 2 sheets one of the sheets has functions written in a module these functions are used for calculations IE

Please Login or Register  to view this content.

Then i have another sheet in which the macro opens up a another workbook then updates links IE:

Please Login or Register  to view this content.

[shg]

From http://www.decisionmodels.com/calcsecretsi.htm:

Opening a .CSV file

Whenever you open a .CSV file, either through VBA or File-->Open, a recalculation of all open workbooks will be triggered, even if calculation is in Manual. Switching off .EnableEvents does not stop this recalculation. The only way I have found to prevent this recalculation from happening is to use VBA to switch Worksheet.EnableCalculation to False for each worksheet that you do NOT want to be calculated.

[Ricardo9211]

Thank you very much, that helped