| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Excel 2003 VBA - setting "iteration" upon loading
Hi!
I have a problem regarding an add-in: I'm trying to set "iteration" in a workbook_open event with the code: Private Sub Workbook_Open() With Application .Iteration = True .MaxIterations = 500 .MaxChange = 0.001 End With But I get the error message "Error 1014, Method 'iteration'of object application failed' when Excel is started and loads the add-in My Excel does not have iteration ticked off as default in the tools/options/calculation. But why can not this be done with VB upon start of Excel ? If the add-in is loaded after Excel have been started, the workbook_open event works ok, and the iteration is set. Any suggestions ? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| "Document not saved" "error in loading DLL" | Excel Discussion (Misc queries) | |||
| Excel 2003: Conditional Formatting using "MIN" & "MAX" function | Excel Discussion (Misc queries) | |||
| Excel - Golf - how to display "-2" as "2 Under" or "4"as "+4" or "4 Over" in a calculation cell | Excel Discussion (Misc queries) | |||
| In Excel 2003 is there a way to prevent "Save As" and "Print"? | Excel Discussion (Misc queries) | |||
| "Loading..." Splash Screen in Excel | Excel Programming | |||
Threaded Mode
