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
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