If you are doing this from a commandbutton, change the TakeFocusOnClick
property of the commandbutton to false. If you are doing it from an event
of one of the other ActiveX controls from the control toolbox toolbar, then
as the first line put in

ActiveCell.Activate

This was a bug in Excel 97 that has been fixed in later versions.

--
Regards,
Tom Ogilvy

"Martiin" wrote in message
...
I am attempting to switch the calculation methd to manual,
but I am constantly getting a run-time error 1004,
Application Method failed. I am using Excel 97 with SR-2,
on Windows NT

I have tried havin the code either in the event routine or
in a macro on a module. Neither works!

HAs anyone else experienced this? How do I solve the
problem?

Thanks in anticipation
Martin