Dear all

I have added a macro to a spreadsheet model developed by a friend, and
am finding that in my macro the application.calculate function is not
working.

Is it possible that one of the other macros that run when the workbook
is opened may have disabled application.calculate, and if so, is there
a way of re-enabling application.calculate?

Thanks

JT

Application.Calculation = xlAutomatic


Gord Dibben MS Excel MVP

On Tue, 8 Jul 2008 09:21:26 -0700 (PDT), JT wrote:

Dear all

I have added a macro to a spreadsheet model developed by a friend, and
am finding that in my macro the application.calculate function is not
working.

Is it possible that one of the other macros that run when the workbook
is opened may have disabled application.calculate, and if so, is there
a way of re-enabling application.calculate?

Thanks

JT