How to stop help from poping up

[DRV]

I created an auto_open macro to set up a workbook which has a circular calculation. I set the options, calculations, iteration check box with the Autpen macro such that the spreadsheet functions will resolve the circular error. My problem is that when I open the file, the spreadsheet loads before the auto_open settings are made. As a result the help topic for circular error pops up. Is there a way to set the options before the sheets load to prevent the help window from appearing? or to turn help off automatically?


Sub auto_open()
With Application
.Iteration = True
.MaxChange = 0.001
End With
AddIns("Analysis ToolPak").Installed = True
AddIns("Solver Add-in").Installed = True
ActiveWorkbook.PrecisionAsDisplayed = False
End Sub

 

[Earl Kiosterud]

DRV,

Try Workbook_Open, in the ThisWorkbook module, instead of Autpen.
Autpen is a legacy thing.
--
Earl Kiosterud
mvpearl omitthisword at verizon period net
-------------------------------------------

I created an auto_open macro to set up a workbook which has a circular

calculation. I set the options, calculations, iteration check box with the
Autpen macro such that the spreadsheet functions will resolve the
circular error. My problem is that when I open the file, the spreadsheet
loads before the auto_open settings are made. As a result the help topic for
circular error pops up. Is there a way to set the options before the sheets
load to prevent the help window from appearing? or to turn help off
automatically?