MrExcel Publishing
Your One Stop for Excel Tips & Solutions

Iteration answer from Bariloche - Question

Posted by Kim on December 11, 2001 12:54 PM

I did as was suggested and entered the info in the ThisWorkBook code sheet. It does set the iterations and calculate the sheet, but is there a way to have this happen without the NAG screen coming up?

Text Entered
Private Sub Workbook_Open()
.Iteration = True
.MaxIterations = 100
.MaxChange = 0.001
End With
End Sub


Posted by Bariloche on December 11, 2001 6:14 PM


You can uncheck the box that says "Always ask before ..." to stop the "Nag screen" from popping up, but I wouldn't recommend it.

That dialog box is to warn folks that there's a macro attached to the workbook (obviously) so that in case they aren't expecting such a thing they can take alternative action. I know what you mean, though. When I saw that box pop up the first time (in E97) I thought "Damn! There goes the surprise!" I pretty much want my macros to run seamlessly without the user even knowing they are there. But then, so do the perveyours of viruses. So, this is the price we pay at the moment for some security.

take care