Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Turning Off Circular Refrences on open
Hi all,
I have set the max number of Iterations to 1 in calcuation, so I do not get circular references for a particular workbook, and then turned iterations off again on close, using the following code... Private Sub Workbook_Open() With Application .Iteration = True .MaxIterations = 1 .MaxChange = 0.001 End With ActiveWorkbook.PrecisionAsDisplayed = False End Sub Private Sub Workbook_BeforeClose(Cancel As Boolean) With Application .Iteration = False .MaxIterations = 100 .MaxChange = 0.001 End With ActiveWorkbook.PrecisionAsDisplayed = False End Sub The problem is that when I open this workbook again, Excel tells me that I have circuar references before running Workbook_open() which turns on iterations, as the current setting has iterations turned off, which I toggled when closing this workbook. How can I tell excel not to check for circular references BEFORE running the workbook_open() sub?? Best regards, Bhupinder |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Turning Off Circular Refrences on open
While the settings are stored with the workbook, they are application level
settings, so only the first workbook opened determines the application level setting. As you say, code does not run before this is checked. So there is no way you can do this within the subject workbook. -- Regards, Tom Ogilvy "Bhupinder Rayat" wrote in message ... Hi all, I have set the max number of Iterations to 1 in calcuation, so I do not get circular references for a particular workbook, and then turned iterations off again on close, using the following code... Private Sub Workbook_Open() With Application .Iteration = True .MaxIterations = 1 .MaxChange = 0.001 End With ActiveWorkbook.PrecisionAsDisplayed = False End Sub Private Sub Workbook_BeforeClose(Cancel As Boolean) With Application .Iteration = False .MaxIterations = 100 .MaxChange = 0.001 End With ActiveWorkbook.PrecisionAsDisplayed = False End Sub The problem is that when I open this workbook again, Excel tells me that I have circuar references before running Workbook_open() which turns on iterations, as the current setting has iterations turned off, which I toggled when closing this workbook. How can I tell excel not to check for circular references BEFORE running the workbook_open() sub?? Best regards, Bhupinder |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
excel 07, i don't want circular reference arrows every time I open | Excel Discussion (Misc queries) | |||
Turning off Circular Error Help | Excel Discussion (Misc queries) | |||
Returning Cell Refrences/range Refrences | Excel Programming | |||
Turning off circular reference warning | Excel Programming | |||
remote refrences | Excel Programming |