Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Calculation Method Failed
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Calculation Method Failed
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 |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Calculation Method Failed
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Method Add of object Validation Failed - please help | New Users to Excel | |||
Method Add of object Validation Failed - please help | Excel Worksheet Functions | |||
Method 'Copy' of object'_Worksheet failed | Excel Worksheet Functions | |||
Method ~ of Object ~ Failed. | Excel Programming | |||
Copy Method of Workseet Class Failed | Excel Programming |