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 <(E-Mail Removed)> 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