Hi guys this is my problem:
I've wrote a VBA appplication in Excel97 and I need this application to activate manual Calculation. I do it with this:
Application.Calculation = xlCalculationManual
Then, I would like to add a button, a real one using a "command button". But when the click event of this button executes the application, excel abort it in the manual calculation activation instruction (Application.Calculation = xlCalculationManual)
Why? I don't know. I can assign a Macro to an Autoform shape and it works OK. Executing the macro with the "Execute Macro" button in the VB ToolBar works just fine too.