Post your code for comments

--
Don Guillett
SalesAid Software

"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