PDA

View Full Version : Workbook_Open executes after a pop-up box



djapigo
04-09-2008, 06:52 PM
I simply want to turn on Iteration (Tools, option) when opening my spreadsheet.

Our company's Excel (intranet application) "resets" without the Iteration checked and when users open my spreadsheet, a pop-up box warns them of a circular reference. So somehow, I have to create an automatic way of turning on the Iteration without the user knowing about it.

I purposely placed a circular reference there (complicated formula) and our users get scared when they see it when they open the spreadsheet.

I figured to simply placed this macro to avoid this:
> Private Sub Workbook_Open()
> Application.Iteration = True
> End Sub

But, a pop-up box still apprears... once you press the OK button, then the Workbook_Open is executed.

Is there a way to remove this pop-up box? Or a work around to not warn of a circular reference?

Any help will be greatly appreciated.

Thank you,
Dennis

\/Ba41337Pwn
04-09-2008, 08:27 PM
Try dropping this...

Private Sub Workbook_Open()
Application.DisplayAlerts = False
Application.Iteration = True
Application.DisplayAlerts = True
End Sub

I throw turning it back on in case there are other alerts you still want to come up, otherwise you could just leave it off.

djapigo
04-10-2008, 09:31 AM
Thanks for the reply, \/Ba...

But the problem is still there...

The alert still comes up before the Worksheet_Open is executed...

Any other ideas?

Thanks,
Dennis